mysql> create table category{
cat_id int unsigned primary key,
cat_name varchar(20),
parent_id int unsigned
}engine=innodb default charset=utf8 ;
alter database imooc default character set'utf8';
set character_set_client='utf8';
set character_set_connection='utf8';
set character_set_results='utf8';
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{
cat_id int unsigned primary key,
cat_name varchar(20),
parent_id int unsign' at line 1
Query OK, 1 row affected
Query OK, 0 rows affected
Query OK, 0 rows affected
Query OK, 0 rows affected