Mysql自增设置

下次自增初始值设定

ALTER TABLE user_task AUTO_INCREMENT=61336

关联查询

SELECT ut.id, rr.id,rr.reviewer_result  from user_task ut LEFT JOIN review_result rr ON(rr.result_id=ut.review_result_id) WHERE rr.reviewer_result LIKE "？%" and field_name="chineseName"