tr-footstone/tr-test/src/main/resources/sql/test1.sql

-- -- 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);