sqlite一次批量插入多条数据

2021-08-19  本文已影响0人  飞哥278999401
SELECT 'aaa' AS 'flowid',  123 AS 'generatedid','0001' AS 'itemId','http:' AS 'itempicture','mone' AS 'memo','123123' AS 'merchantid','dddd' AS 'smallpicture','1' AS 'TSflag' 

UNION  SELECT 'data3',1233,'data3', 'data4','data3', 'data4', 'data4', 'data4'

UNION  SELECT 'data4',1234,'data3', 'data4','data3', 'data4', 'data4', 'data4'

注意 类型要匹配,比如generatedid是int 就不能加引号

上一篇下一篇

猜你喜欢

热点阅读