为什么我的创建数据库语句有错?
-
SQL code
create database registext ( userid smallint unsigned not null auto_increment, username varchar(10) not null unique, userpassword varchar(20) not null, email varchar(20) not null, primary key(userid) );
显示错误:
ERROR 1064 (42000): 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 ‘(
userid smallint unsigned not null auto_increment,
username varchar(10) not nul’ at line 1
应该是create table吧
create table registext (
userid smallint unsigned not null auto_increment,
username varchar(10) not null unique,
userpassword varchar(20) not null,
email varchar(20) not null,
primary key(userid)
);
你是创建表吧
create table registext (
userid smallint unsigned not null auto_increment,
username varchar(10) not null unique,
userpassword varchar(20) not null,
email varchar(20) not null,
primary key(userid)
);
创建数据库
create database registext ;
create table registext(…