My SQL 插入数据前判断

mac2026-02-15  15

INSERT into class(`name`,`number`) select 'rr12','123' FROM DUAL WHERE NOT EXISTS(SELECT * FROM class WHERE `name` = 'rr12');

 

最新回复(0)