create table role(
rid int auto_increment not null primary key,
rname varchar(30)
)
-- user table
create table users(
uid int not null auto_increment primary key,
rid int not null,
uname varchar(20) not null unique,
upassword varchar(20) not null,
perName varchar(20) not null,
ustatus int default 1,
constraint fk_role_user foreign key (rid) references role(rid)
)错误信息:
Script line: 4 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 ')
create table users(
uid int auto_increment not null primary key,
rid int ' at line 4----------------------------------------------------------------------------环境:绿色版
mysql-gui-tools-noinstall-5.0-r14-win32
和
mysql-noinstall-5.1.45-win32
---------------------------------------------------------------
谢谢!急用!!!
rid int auto_increment not null primary key,
rname varchar(30)
)
-- user table
create table users(
uid int not null auto_increment primary key,
rid int not null,
uname varchar(20) not null unique,
upassword varchar(20) not null,
perName varchar(20) not null,
ustatus int default 1,
constraint fk_role_user foreign key (rid) references role(rid)
)错误信息:
Script line: 4 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 ')
create table users(
uid int auto_increment not null primary key,
rid int ' at line 4----------------------------------------------------------------------------环境:绿色版
mysql-gui-tools-noinstall-5.0-r14-win32
和
mysql-noinstall-5.1.45-win32
---------------------------------------------------------------
谢谢!急用!!!
如
create table `users`(
rid int auto_increment not null primary key,
rname varchar(30)
);
-- user table
create table users(
uid int not null auto_increment primary key,
rid int not null,
uname varchar(20) not null unique,
upassword varchar(20) not null,
perName varchar(20) not null,
ustatus int default 1,
constraint fk_role_user foreign key (rid) references role(rid)
);
rid int auto_increment not null primary key,
rname varchar(30)
);-- user table
create table users(
uid int not null auto_increment primary key,
rid int not null,
uname varchar(20) not null unique,
upassword varchar(20) not null,
perName varchar(20) not null,
ustatus int default 1,
constraint fk_role_user foreign key (rid) references role(rid)
);
搞定,楼主的问题在于:
1,)是全角的,不是半角的,所以报错:
2,每个create table最后面需要加上半角; 符号的。
mysql> use csf;
Database changed
mysql> create table role(
-> rid int auto_increment not null primary key,
-> rname varchar(30)
-> );
Query OK, 0 rows affected (0.08 sec)mysql> -- user table
mysql> create table users(
-> uid int not null auto_increment primary key,
-> rid int not null,
-> uname varchar(20) not null unique,
-> upassword varchar(20) not null,
-> perName varchar(20) not null,
-> ustatus int default 1,
-> constraint fk_role_user foreign key (rid) references role(rid)
-> );
Query OK, 0 rows affected (0.06 sec)mysql>
mysql>