INSERT INTO tablename(date_time, OP_id,similarity) SELECT '2022-11-06 21:39:58', '154422',0.9929342 WHERE NOT EXISTS(SELECT * FROM tablename where OP_id='154422' and date_time >='2022-11-06 21:36:58')
sqlite条件插入语句
最新推荐文章于 2024-07-15 21:39:15 发布
INSERT INTO tablename(date_time, OP_id,similarity) SELECT '2022-11-06 21:39:58', '154422',0.9929342 WHERE NOT EXISTS(SELECT * FROM tablename where OP_id='154422' and date_time >='2022-11-06 21:36:58')