插入数据
-
MYSQL插入数据时防止重复命令代码
insert into songinfo(songname,songtime,songpath) select 'aaa','bb' ,'cc' from dual where not exists(select * from songinfo where songname='123') //上述命令在MYSQL3.x版本上不能执行,5.0.24的可以 比如我的Mysql当中某data...
insert into songinfo(songname,songtime,songpath) select 'aaa','bb' ,'cc' from dual where not exists(select * from songinfo where songname='123') //上述命令在MYSQL3.x版本上不能执行,5.0.24的可以 比如我的Mysql当中某data...