Many ways to add column to existing table in MySQL. If you r using GUI tools, add column to table in MySQL is easy. If you are using CLI, then here’s the command to add column in MySQL table.
To add column in existing table, you may refer to the 2 examples below:-
Advertisements
Example I: Add new varchar column to the end of the table
ALTER TABLE `tablename_here` ADD `new_column_name` VARCHAR( 255 ) NOT NULL ;
Example II: Add new integer column after an existing column in table
ALTER TABLE `tablename_here` ADD `new_column_name` INT NOT NULL AFTER `existing_column` ;
It’s simple to add column to existing table right? 🙂
Related posts:
Free FTP Client for Mac OS X / Win XP / Vista
MySQL 5.5 PDO::__construct(): The server requested authentication method unknown to the client [mysq...
How to set print area in Calc - OpenOffice
Symfony: PHP Fatal error: Call to a member function setData()
Turn on MySQL query cache to speed up query performance?
How to import contacts from Mac to Nokia N900
phpmyadmin disable 1440 timeout with auto login
How to disable ssh root login?
Share this with your friends:-
ok. I already know how to do it:
alter table table_name add column user_id int, add foreign key(user_id) references user(id);
and if the new key is a constraint, like a foreign key?