大力出逗比

解决mysql最大值自动增长语句错误问题
修改前:INSERT into rdsay(p_id,id,say,catname,cat,source)&nbs...
扫描右侧二维码阅读全文
05
2016/04

解决mysql最大值自动增长语句错误问题

修改前:

INSERT into rdsay(p_id,id,say,catname,cat,source) 

VALUES ((select max(p_id) from rdsay)+1,1234523,"aaa","bbb","ccc","ddd");


修改后:

INSERT into rdsay(p_id,id,say,catname,cat,source) 

select max(p_id)+1,23189991720,"34567","Anime ","a","asfd"

from rdsay;

Last modification:January 1st, 1970 at 08:00 am
If you think my article is useful to you, please feel free to appreciate

Leave a Comment