这段创建表的sql语言哪有问题？
create table group
(
groupname varchar(20) not null,
owner varchar(20) not null,
membernum tinyint default 0,
memberlist blob,
index(groupname)
);
老提示错误，看不出来
group 是关键字，换个名字吧
create table group???
(
groupname varchar(20) not null,
owner varchar(20) not null,
membernum tinyint default 0,
memberlist blob,？？？？blob??
index(groupname)？？//？ index ?
);
赞一个
memberlist blob,
index(groupname) 这两句有问题，去掉就好了
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 t
ear ''groupa'
(
groupname varchar(20) not null,
owner varchar(20) not null,
' at line 1
mysql> create table groupa
-> (
-> groupname varchar(20) not null,
-> owner varchar(20) not null,
-> membernum tinyint default 0,
-> memberlist blob,
-> index(groupname)
-> )
相关问答：
本人c#新手 可是要求要用c# ，sql2000开发c/s的工作流，一头雾水，请大家帮忙帮忙，给点思路，说的约具体越好，我也好往那个方面去学习
http://www.hxzi.com/view/61402.html
B/S版的，基本思想应该差不多的。。 ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),执行速度慢的要死，但是如果把(xxf>0 and ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
