How to change Column size of varchar type in mySQL? [duplicate]
ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);
Or use CHANGE, but that means you have to give the column name twice (because CHANGE allows you to change the name of the column too).
ALTER TABLE emp CHANGE COLUMN name name VARCHAR(100);
Don't put the column name in single-quotes. Single-quotes are for string literals or date literals.