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 就不能加引号