1 2 3 4 5 6 7 8
create table articles ( id int(5) not null auto_increment primary key, title varchar(100) not null, author varchar(100) not null, category varchar(100) not null, abstract text CHARACTER SET utf8 not null, content text CHARACTER SET utf8 not null );