这段创建表的sql语言哪有问题？
create table group
(
groupname varchar(20) not null,
owner varchar(20) not null,
membernum tinyint default 0,
memberlist blob,
index(groupname)
);

老提示错误，看不出来

[解决办法]
group 是关键字，换个名字吧
[解决办法]

SQL code

mysql> create table 'groupa'    -> (    ->   groupname varchar(20) not null,    ->   owner varchar(20) not null,    ->   membernum tinyint default 0,    ->   memberlist blob,    ->   index(groupname)    -> );ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds tear ''groupa'(  groupname varchar(20) not null,  owner varchar(20) not null, ' at line 1mysql> create table groupa    -> (    ->   groupname varchar(20) not null,    ->   owner varchar(20) not null,    ->   membernum tinyint default 0,    ->   memberlist blob,    ->   index(groupname)    -> );Query OK, 0 rows affected (1.02 sec)
[解决办法]
create table group1 /*换个名*/
(  
 groupname varchar(20) not null,  
 owner varchar(20) not null,  
 membernum tinyint default 0,  
 memberlist blob,  
 index(groupname)  
);  
定义gropname为索引还不如直接定义他为主键