美文网首页
sqlite一次批量插入多条数据

sqlite一次批量插入多条数据

作者: 飞哥278999401 | 来源:发表于2021-08-19 14:40 被阅读0次
    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 就不能加引号

    相关文章

      网友评论

          本文标题:sqlite一次批量插入多条数据

          本文链接:https://www.haomeiwen.com/subject/gqxabltx.html