settable_type=InnoDB;showvariableslike'table_type';SETcharacter_set_client=gbk;SETcharacter_set_connection=gbk;SETcharacter_set_database=gbk;SETcharacter_set_results=gbk;...
set table_type=InnoDB;
show variables like 'table_type';
SET character_set_client=gbk;
SET character_set_connection=gbk;
SET character_set_database=gbk;
SET character_set_results=gbk;
SET character_set_server=gbk;
SET collation_connection=gbk_chinese_ci;
SET collation_database=gbk_chinese_ci;
SET collation_server=gbk_chinese_ci;
show variables like 'character%';
show variables like 'collation%';
create database news;
use news;
create table category(
category_id int auto_increment primary key,
name char(20) not null
);
create t