How to change MySQL column definition

Question

I have a mySQL table called test   create table test      locationExpect varchar 120  NOT NULL       I want to change the locationExpect column to   create table test      locationExpect varchar 120        How can it be done quickly

User · Answer

Syntax to change column name in MySql   alter table table name change old column name new column name data type size     Example   alter table test change LowSal Low Sal integer 4

User · Answer

This should do it   ALTER TABLE test MODIFY locationExpert VARCHAR 120

User · Answer

Do you mean altering the table after it has been created  If so you need to use alter table  in particular   ALTER TABLE tablename MODIFY COLUMN new-column-definition  e g   ALTER TABLE test MODIFY COLUMN locationExpect VARCHAR 120

[mysql] How to change MySQL column definition?

Examples related to mysql

Examples related to alter-table