use anine
create table newest_product(Item_no char(20),Type char(20),Available_color char(50),Product_info1 char(800),Service char(800),Size char(20),Sheet char(20),Package char(20),Cover_material char(50),Cnt_size char(30),Gw char(20),Small_picture char(100),Middle_picture char(100),Larger_picture char(100),Corner_picture char(100),Edge_picture char(100),stocks int,Ttime datetime,Page_size char(20),Available char(20),Product_info2 char(800),Product_info3 char(800),Product_info4 char(800),Product_info5 char(800),Product_info6 char(800));
这是我的建表语句,大家帮我改下,我以前用的是sql,mysql一点也不会,工作需要,时间紧,现在要用,错误提示是:
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 'create table newest_product(Item_no char(20),Type char(20),Available_color char(' at line 2
(耗费 0 ms)
create table newest_product(Item_no char(20),Type char(20),Available_color char(50),Product_info1 char(800),Service char(800),Size char(20),Sheet char(20),Package char(20),Cover_material char(50),Cnt_size char(30),Gw char(20),Small_picture char(100),Middle_picture char(100),Larger_picture char(100),Corner_picture char(100),Edge_picture char(100),stocks int,Ttime datetime,Page_size char(20),Available char(20),Product_info2 char(800),Product_info3 char(800),Product_info4 char(800),Product_info5 char(800),Product_info6 char(800));
这是我的建表语句,大家帮我改下,我以前用的是sql,mysql一点也不会,工作需要,时间紧,现在要用,错误提示是:
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 'create table newest_product(Item_no char(20),Type char(20),Available_color char(' at line 2
(耗费 0 ms)
解决方案 »
- lucene去重复索引
- 求助:关于Struts2+ajax验证用户是否存在的问题
- java new之后重新分配内存空间吗?
- 求一个正则表达去掉文本中的javascript
- 在ActionForm中如何获取资源文件里的键值?我是说直接取得某个键值并赋给一个变量.
- FCKeditor.java : xml request error:internal server error(500)
- 如何把",'zhang','liu','li'" 中的zhang ,liu ,li 取出来,应该用什么方法
- 请教高手,关于用javamail发邮件的问题~~ 在线等!!!
- 请教JS脚本问题。急!!!
- 关于jsp include
- stuts logic:equal 标签使用
- 有关正则表达式的一个问题
我刚才试了 语句没问题,你把整个语句写成一行看看怎么样
create table newest_product
(Item_no char(20),
Type char(20),
Available_color char(50),
Product_info1 blob,
Service blob,
Size char(20),
Sheet char(20),
Package char(20),
Cover_material char(50),
Cnt_size char(30),
Gw char(20),
Small_picture char(100),
Middle_picture char(100),
Larger_picture char(100),
Corner_picture char(100),
Edge_picture char(100),
stocks int,Ttime datetime,
Page_size char(20),
Available char(20),
Product_info2 blob,
Product_info3 blob,
Product_info4 blob,
Product_info5 blob,
Product_info6 blob);
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 'create table newest_product(Item_no char(20),Type char(20),Available_color char(' at line 2
(耗费 0 ms)
你们运行一下看行吗?