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, 1737🔥, 0💬
Popular Posts:
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...