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
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 ;