在Mac终端内 ‘creat database my_database character set utf8mb4;’ 语句为完整形式的创建数据库语句,如使用Win系统的 ‘create database my_database charset=utf8;’ 则会报错:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'creat database my_database charset=utf8' at line 1.
其缩写形式:
creat database my_database charset utf8mb4; or create database my_database charset=utf8mb4;
希望能够帮到你。