mysql语句

mysql数据库自增字段起始值设置
alter table tablename auto_increment = 这里是你设置的起始值;
例如：ALTER TABLE `retrieval_goods_image` auto_increment=1;

查看某个字段中是否存在某个字符串
SELECT * FROM `tb_goods_image_for_train_v1` WHERE not instr(img_info, 'category') GROUP BY srcid;