摘要:
Duplicate entry '0' for key 'PRIMARY'一查,发现表没有设置自增长。尝试增加修改表,添加自增长。ALTER TABLE sh_incentive_item MODIFY id SMALLINT UNSIGNED AUTO_INCREMENT;报错[SQL] ALT... 阅读全文
摘要:
语句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... 阅读全文