#1064 - 您的SQL语法出错;检查与您的mysql服务器版本对应的手册,以便在'(100)NOT NULL附近使用正确的语法 [英] #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 '(100) NOT NULL
本文介绍了#1064 - 您的SQL语法出错;检查与您的mysql服务器版本对应的手册,以便在'(100)NOT NULL附近使用正确的语法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
需要找到这个错误
无法找到它请帮助
我是什么尝试过:
CREATE TABLE tbl_images
(
img_id int(100)NOT NULL AUTO_INCREMENT,
name varchar(100)NOT NULL,
image longblob(100)NOT NULL,
size int(15)NOT NULL,
type varchar(12)NOT NULL,
PRIMARY KEY(img_id)
);
解决方案
尝试
CREATE TABLE tbl_images
(
img_id int(11)NOT NULL AUTO_INCREMENT,
name varchar(100)NOT NULL,
image longblob(100)NOT NULL,
size int(15)NOT NULL,
type varchar(12)NOT NULL,
PRIMARY KEY(img_id)
);
参见MySQL :: MySQL 5.5参考手册:: 11.2.1整数类型(精确值) - INTEGER,IN T,SMALLINT,TINYINT,MEDIUMINT,BIGINT [ ^ ]
Int最大尺寸为11(包含10个数字+负号)
< blockquote>您正在为整数列和longblob列指定字段大小。你不能这样做。
我不做MySQL,但我认为CREATE TABLE语句应该是这样的:
CREATE TABLE tbl_images
(
img_id int NOT NULL AUTO_INCREMENT,
name varchar(100)NOT NULL,
image longblob NOT NULL,
size int NOT NULL,
类型varchar(12)NOT NULL,
PRIMARY KEY(img_id)
};
need to find this error
cant find it please help
What I have tried:
CREATE TABLE tbl_images
(
img_id int (100) NOT NULL AUTO_INCREMENT,
name varchar (100) NOT NULL,
image longblob (100) NOT NULL,
size int (15) NOT NULL,
type varchar (12) NOT NULL,
PRIMARY KEY (img_id)
);
解决方案
Try
CREATE TABLE tbl_images ( img_id int (11) NOT NULL AUTO_INCREMENT, name varchar (100) NOT NULL, image longblob (100) NOT NULL, size int (15) NOT NULL, type varchar (12) NOT NULL, PRIMARY KEY (img_id) );
See MySQL :: MySQL 5.5 Reference Manual :: 11.2.1 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT[^]
Int maximun size is 11 (consisting of 10 numbers + negative sign)
You're specifying a field size for your integer columns and the longblob column. You can't do that.
I don't do MySQL but I think the CREATE TABLE statement should be something like:
CREATE TABLE tbl_images ( img_id int NOT NULL AUTO_INCREMENT, name varchar (100) NOT NULL, image longblob NOT NULL, size int NOT NULL, type varchar(12) NOT NULL, PRIMARY KEY (img_id) };
这篇关于#1064 - 您的SQL语法出错;检查与您的mysql服务器版本对应的手册,以便在'(100)NOT NULL附近使用正确的语法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文