#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax in creating table

Asked Aug 20 '23 at 12:09

Active Aug 20 '23 at 12:11

Viewed 21 times

-1

Trying to create a table in sql server i want to store image in my table following is the query I'm running

create table user_profile (sr_no int(10) auto_increment,u_id int(10),
username varchar(30), profile_pic varbinary(max), gender varchar(6),
country_code int(5),  phoneno int(10), addline1 varchar(30), addline2
varchar(50), addline3 varchar(20),  towncity varchar(30), state
varchar(30), pincode int(6), foreign key (username) references
login(uname), foreign key (u_id) references signup(u_id), primary key
(sr_no))

and sql is throwing me this error

#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 'max), gender varchar(6), country_code int(5), phoneno int(10), addline1 varcha' at line 3

edited Aug 20 '23 at 12:11

Thom A

88,727
11
45
75

asked Aug 20 '23 at 12:09

tanmay thakur

Ok i read that, i guess setting it as 255 would do? Let me try it! Thanks in advance! – tanmay thakur Aug 20 '23 at 12:16
That isn't what the [answer](https://stackoverflow.com/a/26831244/2029983) says to do. Though, if 255 bytes is enough for your images then you could do that. I doubt it though. 255 bytes is just too small for a 16x16 px BMP file. – Thom A Aug 20 '23 at 12:28
yep you're right – tanmay thakur Aug 20 '23 at 12:43
what if i use LONGBLOB? – tanmay thakur Aug 20 '23 at 12:44

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax in creating table

0 Answers0