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
|
1 |
ALTER TABLE `tablename_here` ADD `new_column_name` VARCHAR( 255 ) NOT NULL ; |
Example II: Add new integer column after an existing column in table
|
1 |
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:
WordPress Custom Taxonomy Pagination show 404 page not found error
How to use apt to list available packages?
Symfony Filter: Change ForeignKey drop down to Text field
MySQL: Full text search for multiple words
How to import mysql innodb with foreign key constraint error?
Symfony: PHP Fatal error: Call to a member function setData()
How to install apache, php, mysql with macport in Mac OS X
Debian: "There is no public key available for the following key IDs"
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?