Collections:
Add a New Column to an Existing Table in MySQL
How To Add a New Column to an Existing Table in MySQL?
✍: FYIcenter.com
If you have an existing table with existing data rows, and want to add a new column to that table, you can use the "ALTER TABLE ... ADD COLUMN" statement. The tutorial script below shows you a good example:
mysql> ALTER TABLE tip ADD COLUMN author VARCHAR(40); Query OK, 1 row affected (0.18 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> SHOW COLUMNS FROM tip; +-------------+--------------+------+-----+---------+------- | Field | Type | Null | Key | Default | Extra +-------------+--------------+------+-----+---------+------- | id | int(11) | NO | PRI | | | subject | varchar(80) | NO | | | | description | varchar(256) | NO | | | | create_date | date | YES | | NULL | | author | varchar(40) | YES | | NULL | +-------------+--------------+------+-----+---------+------- 5 rows in set (0.01 sec)
This SQL script added a new column called "author" to the "tip" table. NULL values were added to this column on all existing data rows.
⇒ Delete an Existing Column in a Table in MySQL
⇐ Creating New Tables with SELECT Statements in MySQL
2018-03-04, 1553🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...