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, 1528🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...