+ 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?
1 Respuesta
+ 10
//to change column name & datatype (if required)
ALTER TABLE tablename
CHANGE oldName newName varchar(100);
https://www.sololearn.com/learn/SQL/1872/