Mysql syntax error in ALTER TABLE

Question

Sql keeps throwing me a syntax error and I can't seem to figure out whats wrong.

ALTER TABLE `productList` ALTER COLUMN `ASIN` VARCHAR(32);

The error is the normal sql syntax error

ERROR 1064 (42000): 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 'VARCHAR(32)' at line 1

Rahul Tripathi · Accepted Answer · 2015-09-02 18:09:55Z

3

Try this:

 ALTER TABLE `productList` MODIFY COLUMN `ASIN` VARCHAR(32);

The syntax to change the column name is

ALTER TABLE tablename MODIFY COLUMN new-column-definition

edited Sep 2, 2015 at 18:09

answered Sep 2, 2015 at 18:08

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

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

2 Comments

Ryan Weinstein Over a year ago

This was correct. Thanks, it was driving me crazy. All the answers online said I could use ALTER COLUMN. I'll mark this correct in 10 minutes.

Rahul Tripathi Over a year ago

@RyanWeinstein:- Added the manual link also . You can refer that as well!

Willem Renzema · Accepted Answer · 2015-09-02 18:08:51Z

0

You need to use MODIFY COLUMN instead of ALTER COLUMN if you want to change the column definition.

https://dev.mysql.com/doc/refman/5.1/en/alter-table.html

answered Sep 2, 2015 at 18:08

Willem Renzema

5,1861 gold badge20 silver badges27 bronze badges

Comments

CargoMeister · Accepted Answer · 2015-09-02 18:10:29Z

0

It's modify, not alter column.

ALTER TABLE table_name MODIFY column_name column_definition [ FIRST | AFTER column_name ];

answered Sep 2, 2015 at 18:10

CargoMeister

4,3576 gold badges30 silver badges46 bronze badges

Collectives™ on Stack Overflow

Mysql syntax error in ALTER TABLE

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related