Is there any syntax error in this MySQL code?

Question

I would like to create a column in a table, with data type BLOB and attribute BINARY, however, MySQL always says that there is a syntax error in my code, I cannot see any.

My code is:

ALTER TABLE `Users` CHANGE `user_image` `user_image` BLOB BINARY NULL DEFAULT NULL;

And the error message is:

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 'BINARY NULL DEFAULT NULL' at line 1.

searain · Accepted Answer · 2019-02-11 18:52:55Z

0

Modify existing column

ALTER TABLE table_name
MODIFY COLUMN column_name datatype;

Add a new column

ALTER TABLE table_name
ADD column_name datatype;

answered Feb 11, 2019 at 18:52

searain

3,3217 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

WenZ Over a year ago

It doesn't work...I got the same error again. It seems that the BINARY attribute caused the problem, because every time the error message says "check the manual that corresponds to your MySQL server version for the right syntax to use near 'BINARY NULL DEFAULT NULL' at line 1."

searain Over a year ago

datatype should be either blob or binary, stackoverflow.com/questions/7421933/…

Collectives™ on Stack Overflow

Is there any syntax error in this MySQL code?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related