New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Alter a table via mysql command line
Hi.
I have a table called servers
and one of the columns inside it is called ipaddress
and it's currently a varchar (15).
I need to change it to varchar (30) without dropping the column.
What would be the correct command to do this.
I searched it up online but most places say to drop it and re-add it.
I don't wanna install PHPMyAdmin.
Comments
Have you tried this?
http://pastebin.com/rxVs6CXf (column name is listed twice as "CHANGE" renames the column, so to keep the same name, you just list it twice).
Try this: https://paste.ee/p/kKhBA
posted there because of cloudflare