INSERT INTO ySysColumns (TableName, ColName, ColOrder, ColType, ColWidth, ColPrecision, ColNull, ColDefault, DisplayLabel, DisplayWidth, DisplayFormat, EditFormat, ColVarify, VarifyMsg, ColVisible, ColProperty)
select 'VIEW_RYMARK', 'ID', '1', 'INT IDENTITY', '4', '0', '0', '', '序号', '120', '', '', '', '', '0', '1'
where not exists(select 1 from ySysColumns where TableName='VIEW_RYMARK' and ColName='ID')
> Affected rows: 0
> 时间: 0.205s
--##--
INSERT INTO ySysColumns (TableName, ColName, ColOrder, ColType, ColWidth, ColPrecision, ColNull, ColDefault, DisplayLabel, DisplayWidth, DisplayFormat, EditFormat, ColVarify, VarifyMsg, ColVisible, ColProperty)
select 'VIEW_RYMARK', 'A0188', '2', 'INT', '4', '0', '0', '', '标签人员', '120', '', 'LOOK(A01|A0188|A0101|)', '', '', '1', '2'
where not exists(select 1 from ySysColumns where TableName='VIEW_RYMARK' and ColName='A0188')
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--##--
INSERT INTO ySysColumns (TableName, ColName, ColOrder, ColType, ColWidth' at line 1
> 时间: 0.13s
最新发布