当前位置:Gxlcms > 数据库问题 > MySQL编码格式

MySQL编码格式

时间:2021-07-01 10:21:17 帮助过:24人阅读

*/ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

2) 查看表和字段的编码格式

mysql> show create table t_user;
+--------+----------------------------------------------------
--------------------------------------------------------------
-----------------------------------------------------------+
| Table  | Create Table

                                                           |
+--------+----------------------------------------------------
--------------------------------------------------------------
-----------------------------------------------------------+
| t_user | CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
  `birth` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk |
+--------+----------------------------------------------------
--------------------------------------------------------------
-----------------------------------------------------------+
1 row in set (0.00 sec)


MySQL编码格式

标签:mysql   编码格式   

人气教程排行