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, 1238👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...