mysql使用笔记

1. Mysql自增ID重置，不需要删除数据

   update table_name SET id = id - ( select min from ( select MIN(id) as min from table_name) as t) - 1;