[SQL]
create table t_department(
departmentID Number not null,
departmentName VARCHAR(20) not null,
duty VARCHAR(20) not null,-- 职能
phone VARCHAR(20) not null,
primary key(departmentID)
);
[Err] 1064 - 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 'Number not null,
departmentName VARCHAR(20) not null,
duty VARCHAR(20) ' at line 2
create table t_department(
departmentID Number not null,
departmentName VARCHAR(20) not null,
duty VARCHAR(20) not null,-- 职能
phone VARCHAR(20) not null,
primary key(departmentID)
);
[Err] 1064 - 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 'Number not null,
departmentName VARCHAR(20) not null,
duty VARCHAR(20) ' at line 2
===============
说的不是很清楚。只是说sql语法 错误在 number 附近。 检查几遍感觉没有错,最后才发现原来是mysql 中 没有number这个数据类型,好吧我是copy oracle的sql语句。来练手的。
简直nice。知道了oracle和mysql的不同,数据类型不同,以及sql语句的写法不同。oracle与sql server 接的更近。