执行sql语句返回:
#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 'order (orderhao,goodsid,goodsnums,address,user,buyphone,status,addtime) VALUES('' at line 1
数据库表: 名字 类型 整理 属性
id int(100) UNSIGNED 否 无 AUTO_INCREMENT
orderhao varchar(255) utf8_general_ci 否 无
user varchar(100) utf8_general_ci 否 无
goodsid varchar(100) utf8_general_ci 否 无
goodsname varchar(100) utf8_general_ci 否 无
goodsprice varchar(100) utf8_general_ci 否 无
goodspic varchar(100) utf8_general_ci 否 无
goodsnums varchar(100) utf8_general_ci
address varchar(100) utf8_general_ci
status varchar(100) utf8_general_ci
addtime varchar(100) utf8_general_ci
buyphone varchar(100) utf8_general_ci sql语句:INSERT INTO order (orderhao,goodsid,goodsnums,address,user,buyphone,status,addtime) VALUES('201412151644291965','31','1','河南省郑州市河南省郑州市金水区文化路93号','李二','22222232222','正在交易','2014-12-15 16:44:29');我错在哪里?
#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 'order (orderhao,goodsid,goodsnums,address,user,buyphone,status,addtime) VALUES('' at line 1
数据库表: 名字 类型 整理 属性
id int(100) UNSIGNED 否 无 AUTO_INCREMENT
orderhao varchar(255) utf8_general_ci 否 无
user varchar(100) utf8_general_ci 否 无
goodsid varchar(100) utf8_general_ci 否 无
goodsname varchar(100) utf8_general_ci 否 无
goodsprice varchar(100) utf8_general_ci 否 无
goodspic varchar(100) utf8_general_ci 否 无
goodsnums varchar(100) utf8_general_ci
address varchar(100) utf8_general_ci
status varchar(100) utf8_general_ci
addtime varchar(100) utf8_general_ci
buyphone varchar(100) utf8_general_ci sql语句:INSERT INTO order (orderhao,goodsid,goodsnums,address,user,buyphone,status,addtime) VALUES('201412151644291965','31','1','河南省郑州市河南省郑州市金水区文化路93号','李二','22222232222','正在交易','2014-12-15 16:44:29');我错在哪里?
2. CREATE TABLE tab_new AS SELECT * FROM [tab_old];