MySQL sql query

 1、查看当前数据库的编码

show variables like 'character_set_%';

输出如下：

----------------------------------------------------------------------

'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'utf8'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'utf8'
'character_set_system', 'utf8'
'character_sets_dir', 'D:\Program Files\MySQL\MySQL Server 5.5\share\charsets\'

 

2、查看某表的所有列

show full columns from photo_image;

3、修改数据库、表、列

alter database upub character set utf8;

alter table photo_image character set utf8;

alter table photo_image modify image varchar(100) CHARACTER SET utf8;