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 就不能加引号
网友评论