UC知道mysql 创建表失败
来源：百度知道 编辑：UC知道 时间：2024/06/07 01:01:20
mysql> create table dept
-> deptno int primary key,
-> dname varchar<14>,
-> loc varchar<13>,
-> >;
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 'deptn
o int primary key,
dname varchar<14>,
loc varchar<13>,
>' at line 2
一直这么报错，真的不知道哪里有问题，谢谢啦！谢谢
开始是create databases mydata;
然后use mydata;
然后就是 建表了。一直这么失败，请各位大侠帮忙。谢谢
-> deptno int primary key,
-> dname varchar<14>,
-> loc varchar<13>,
-> >;
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 'deptn
o int primary key,
dname varchar<14>,
loc varchar<13>,
>' at line 2
一直这么报错，真的不知道哪里有问题，谢谢啦！谢谢
开始是create databases mydata;
然后use mydata;
然后就是 建表了。一直这么失败，请各位大侠帮忙。谢谢
创建数据库：create database mydata; 是database不是databases
创建数据表： create table dept(deptno int primary key, dname varchar(14), loc varchar(13));
创建数据表时开始和结尾要加括号，这里用的是小括号"()"，不是"<>"，虽然mysql命令行显示好像是<>。