Error when trying to modify column data type in MYSQL

Question

I'm trying to change the datatype of a column of one of my tables from TEXT to VARCHAR in my database. I use this simple query which seems correct to me:

ALTER TABLE my_database.my_table MODIFY `SalesRank` VARCHAR;

However I get the error: '' () is not valid input at this position.

What is wrong with my query? The column itself is completely empty. I'm using MYSQL Workbench.

Sagar Gangwal · Accepted Answer · 2017-05-03 12:06:38Z

3

ALTER TABLE my_database.my_table MODIFY `SalesRank` VARCHAR(255);

You missed size of that column. Just try above code.

Hope this will helps you

answered May 3, 2017 at 12:06

Sagar Gangwal

8,1303 gold badges28 silver badges45 bronze badges

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

1 Comment

TheKidsWantDjent Over a year ago

Wow, how did I not see that. Sometimes you're just blind! :D Thank you!

Collectives™ on Stack Overflow

Error when trying to modify column data type in MYSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related