-- -- drop table if exists sys_dept; -- -- -- -- create table `Test1` ( -- -- `Id` int(11) not null comment '默认ID', -- -- `Name` varchar(20) not null comment '默认名字', -- -- primary key (`Id`) -- -- ) engine=innoDB default charset=utf8 comment='test'; -- -- insert into `Test`(`Id`, `Name`) select 1 , 'jack'; -- -- insert into `Test` select 1 , 'cao' where not exists(select 1 from Test where id=1); -- insert into `Test` select 1 , 'cao' from dual where not exists(select 1 from Test where id=1);