mysql> create table dev_log(index int, logtype int, level int, module int, message char(80), logtime_from date ,logtime_to date);
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 'int, logtype int, level int, module int, message char(80), logtime_from date ,lo' at line 1
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 'int, logtype int, level int, module int, message char(80), logtime_from date ,lo' at line 1
解决方案 »
- 关于主外键约束和测试数据问题
- 利用二进制日志恢复报错?Variable 'sql_mode' can't be set to the value of '1344274432'
- 请问on the fly是什么意思
- 数据库开发这点事 中文PDF下载
- mysql存储过程
- vc 下ado 连接mysql问题
- 急,熟悉linux命令的高手请帮忙!!在linux的客户机上怎么用命令导mssql数据库(表结构跟数据)到一个文件中去!!
- 定义变量都出错,这是咋回事啊?
- 请教一个用SQL实现对账功能的思路,望赐教
- sql server 拼接多条记录的某一个字段,见下表,怎么做?
- 求助!如何快速从文件中读取数据导入mysql?
- 如何根据条件insert数据?
`level` INT, module INT, message CHAR(80), logtime_from DATE ,logtime_to DATE);
mysql> create table dev_log('index' INT, logtype INT, 'level' INT, module INT, message CHAR(80), logtime_from DATE ,logtime_to DATE);
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 ''index' INT, logtype INT, 'level' INT, module INT, message CHAR(80), logtime_fro' at line 1
`index`
'index'
mysql> create table dev_log(logindex INT, logtype INT, loglevel INT, module INT, message CHAR(80), logtime_from DATE ,logtime_to DATE);
Query OK, 0 rows affected (0.00 sec)mysql>
成功了