1.illegal mix of collations (GB2312_CHINESE_CI, IMPLICIT) AND (latin1_swedish_ci, implicit) for operation '=' This problem is caused by the character set of the table and the character set of MySQL. The default character set of mysql is changed from Latin1 to GB2312.
2. Set the auto_increment initial value alter table tbl auto_increme = 100