You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
来源:互联网 发布:免费收银软件pfpos 编辑:程序博客网 时间:2024/04/19 18:25
[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 接的更近。
0 0
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
- css link 与@import 异同
- Android监听耳机按键事件
- HDOJ 2222 - Keywords Search 更新AC自动机模板...用类来表示
- shell编程---变量的定义
- DB2 日期字符串转换
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- android ndk 环境
- p51 15
- Parcelable接口
- jquery实现瀑布流并与php实现数据交互
- Python ftplib模块
- 【IOS笔试面试】04-Foundation
- angular on Enter event wrapped into directive
- nyoj 51 管闲事的小明