Collections:
Delete an Existing Column in a Table in MySQL
How To Delete an Existing Column in a Table in MySQL?
✍: FYIcenter.com
If you have an existing column in a table and you do not need that column any more, you can delete it with "ALTER TABLE ... DROP COLUMN" statement. Here is a tutorial script to delete an existing column:
mysql> ALTER TABLE tip DROP COLUMN create_date; Query OK, 1 row affected (0.48 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM tip; +----+-------------+-------------------------+--------+ | id | subject | description | author | +----+-------------+-------------------------+--------+ | 1 | Learn MySQL | Visit dev.fyicenter.com | NULL | +----+-------------+-------------------------+--------+ 1 row in set (0.00 sec)
As you can see the column "create_date" is gone.
⇒ Rename an Existing Column in a Table in MySQL
⇐ Add a New Column to an Existing Table in MySQL
2018-03-04, 1451🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...