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, 1308👍, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...