《Mysql學(xué)習(xí)查看mysql編碼、數(shù)據(jù)表編碼》要點(diǎn)：
本文介紹了Mysql學(xué)習(xí)查看mysql編碼、數(shù)據(jù)表編碼，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。
導(dǎo)讀：本節(jié)內(nèi)容：mysql數(shù)據(jù)庫編碼,mysql表編碼的查看實(shí)例.1,查看mysql的編碼
mysql> show variables like character%; +-----------------...
本節(jié)內(nèi)容：
mysql數(shù)據(jù)庫編碼,mysql表編碼的查看實(shí)例.MYSQL入門
1,查看mysql的編碼
?MYSQL入門
mysql>? show variables like 'character%';?????????????????????
+--------------------------+----------------------------+?
| Variable_name??????????? | Value????????????????????? |?
+--------------------------+----------------------------+?
| character_set_client???? | latin1???????????????????? |??
| character_set_connection | latin1???????????????????? |??
| character_set_database?? |<span style="color:#ff0000;"> utf8? </span>???????????????????? |??
| character_set_filesystem | binary???????????????????? |??
| character_set_results??? | latin1???????????????????? |??
| character_set_server???? | gbk??????????????????????? |??
| character_set_system???? | utf8?????????????????????? |??
| character_sets_dir?????? | /u01/mysql/share/charsets/ |??
+--------------------------+----------------------------+?
2,查看db的編碼
?MYSQL入門
mysql> show create database site001;?
+----------+------------------------------------------------------------------+?
| Database | Create Database????????????????????????????????????????????????? |?
+----------+------------------------------------------------------------------+?
| site001? | CREATE DATABASE `site001` /*!40100 <span style="color:#ff0000;">DEFAULT CHARACTER SET utf8</span> */ |??
+----------+------------------------------------------------------------------+?
1 row in set (0.00 sec)?
3,查看表的編碼
?MYSQL入門
mysql> show create table site_user_page G;?
淫亂淫亂淫亂淫亂淫亂淫亂淫亂淫亂淫亂 1. row 淫亂淫亂淫亂淫亂淫亂淫亂淫亂淫亂淫亂?
?????? Table: site_user_page?
Create Table: CREATE TABLE `site_user_page` (?
? `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pk',?
? `gmt_create` datetime NOT NULL COMMENT '????',?
? `gmt_modified` datetime NOT NULL COMMENT '????',?
? `member_id` varchar(36) NOT NULL COMMENT 'member_id',?
? `page_id` varchar(20) NOT NULL COMMENT 'page_id',?
? `head` text COMMENT '??',?
? `content` text COMMENT 'content',?
? `fly` text COMMENT 'fly',?
? `foot` text COMMENT 'foot',?
? `instance_key` varchar(32) NOT NULL COMMENT 'instancekey',?
? `user_instance_key` varchar(32) NOT NULL COMMENT 'user_instance_key',?
? `page_type` varchar(32) DEFAULT NULL,?
? PRIMARY KEY (`id`),?
? KEY `idx_userInstanceKey` (`user_instance_key`),?
? KEY `idx_instanceKey` (`instance_key`),?
? KEY `idx_userInstanceKey_pageid` (`user_instance_key`,`page_id`),?
? KEY `idx_memberId` (`member_id`)?
) ENGINE=InnoDB AUTO_INCREMENT=101820722 <span style="color:#ff0000;">DEFAULT CHARSET=utf8</span>?
1 row in set (0.00 sec)
歡迎參與《Mysql學(xué)習(xí)查看mysql編碼、數(shù)據(jù)表編碼》討論，分享您的想法，維易PHP學(xué)院為您提供專業(yè)教程。
轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/7438.html
