SQL创建数据库

set table_type=InnoDB;
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;
create database news;
use news;
create table news(
	news_id int auto_increment primary key,
	title char(100),
	content text,
	attachment char(100)
);