+ 1

How to change column name and min for varchar type in MYSQL

If a table is already constructed and i wann to change one of its column name permanently(unlike as) how can i do that? Did min works for varchar type if so then what would be the output?

3rd Mar 2018, 10:02 AM
Manthan singh
Manthan singh - avatar
1 Answer
+ 10
//to change column name & datatype (if required) ALTER TABLE tablename CHANGE oldName newName varchar(100); https://www.sololearn.com/learn/SQL/1872/
3rd Mar 2018, 10:45 AM
Gaurav Agrawal
Gaurav Agrawal - avatar