新手求助数据插入问题！

Question

加个这样的字段 id  bigint(10)  auto_increment然后select max(id) from table

Answer 1

可以用
select * from goods order by class_id,goods_id+1 desc;
然后用程序来取第一个 class_id对应的goods_id.

Answer 2

对了，goods_id的类型技术总监不让改动的

Answer 3

insert goods values('??','??')就行了，哪那么麻烦？！

Answer 4

先取得最大值
SELECT MAX(GOODS_ID) FROM GOODS 负值给$maxGoodid
再执行INSERT语句
insert into goods(goods_id,goods_name,goods_style,class_id,goods_price,goods_intro,goods_pic,".
                    "goods_comefrom,goods_manufacture,goods_date,goods_date1,goods_enable,goods_smallpic)".
                    "values('$maxGoodid','$class_name','$goods_style','$classid','$goods_price','$goods_intro',".
                    "'$goods_pic','','','$goods_date','','$goods_enable','$goods_smallpic')");