为什么我的创建数据库语句有错？

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（...