INSERT INTO ldb
(id, name, rule, liang, prices, [datetime], caozuo)
VALUES ('(select Gid from Goods WHERE (Gid = 2))',
'(select Gname from Goods WHERE (Gid = 2))',
'(select Grule from Goods WHERE (Gid = 2))',
'(select Gliang from Goods WHERE (Gid = 2))',
'(select price from Goods WHERE (Gid = 2))',
'(select [datatime] from Goods WHERE (Gid = 2))', '添加') 标准表达式中数据类型不匹配
(id, name, rule, liang, prices, [datetime], caozuo)
VALUES ('(select Gid from Goods WHERE (Gid = 2))',
'(select Gname from Goods WHERE (Gid = 2))',
'(select Grule from Goods WHERE (Gid = 2))',
'(select Gliang from Goods WHERE (Gid = 2))',
'(select price from Goods WHERE (Gid = 2))',
'(select [datatime] from Goods WHERE (Gid = 2))', '添加') 标准表达式中数据类型不匹配
这些分别什么类型
'(select Gid from Goods WHERE (Gid = 2))',
'(select Gname from Goods WHERE (Gid = 2))',
'(select Grule from Goods WHERE (Gid = 2))',
'(select Gliang from Goods WHERE (Gid = 2))',
'(select price from Goods WHERE (Gid = 2))',
'(select [datatime] from Goods WHERE (Gid = 2))', '添加'
这些取出来的全是字符串类型
能匹配吗
INSERT INTO ldb(id, name, rule, liang, prices, [datetime], caozuo)
Select *,'添加'
from Goods
where Gid = 2
用Insert ... Select语法来实现,其中ldb表不能已经存在或者是手动进行创建。