摘要: Duplicate entry '0' for key 'PRIMARY'一查,发现表没有设置自增长。尝试增加修改表,添加自增长。ALTER TABLE sh_incentive_item MODIFY id SMALLINT UNSIGNED AUTO_INCREMENT;报错[SQL] ALT... 阅读全文
posted @ 2015-12-04 17:15 TBHacker 阅读(15946) 评论(0) 推荐(0) 编辑
摘要: 语句SELECT a.id as item_id,a.name as item_name,a.intro as item_intro,b.id,b.money FROM sh_incentive_item a left join ( SELECT * FROM `sh_incentive` WHER... 阅读全文
posted @ 2015-12-04 15:16 TBHacker 阅读(3928) 评论(0) 推荐(0) 编辑