MySQL notes

xiaoxiao2021-03-14  162

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

转载请注明原文地址:https://www.9cbs.com/read-129400.html

New Post(0)