drop database if exists user
create database user
use user
CREATE TABLE userinfo(
id char(10) NOT NULL,
name varchar(20) NOT NULL,
sex int(2) NOT NULL,
position varchar(20) NOT NULL,
contact varchar(20) NOT NULL,
rights char(20) NOT NULL,
loginnum varchar(20) NOT NULL ,
passnum varchar(20) NOT NULL ,
PRIMARY KEY (id)
);
结果报以下错误!
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 'creat
e database user
use user
CREATE TABLE userinfo(
id char(10) NOT N' at line 2
各路大神帮帮忙!
create database user
use user
CREATE TABLE userinfo(
id char(10) NOT NULL,
name varchar(20) NOT NULL,
sex int(2) NOT NULL,
position varchar(20) NOT NULL,
contact varchar(20) NOT NULL,
rights char(20) NOT NULL,
loginnum varchar(20) NOT NULL ,
passnum varchar(20) NOT NULL ,
PRIMARY KEY (id)
);
结果报以下错误!
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 'creat
e database user
use user
CREATE TABLE userinfo(
id char(10) NOT N' at line 2
各路大神帮帮忙!
use user;是不是这边要加“;”号啊
create database user
use user
这三句后面都要加分号 ;
不然MySQL认为是一句话
drop database if exists user create database user use user
肯定报错啦
mysql 建表最好还是要加上编码吧,否则到时出现乱码就头痛了。