SQLite 不存在则insert
1. 不存在则Insertinsert into [tableName]([columnName1], [columnName2]) select value1, value2where not exists (select * from [tableName] where [columnName1]=value1);/* 实例代码 */INSERT INTO student (id,name) SELECT 101, 'Hush' WHERE NOT EXISTS (SELECT * FRO
原创
2021-01-30 21:03:56 ·
2735 阅读 ·
1 评论