Delete an Existing Column in a Table in MySQL

Q

How To Delete an Existing Column in a Table in MySQL?

✍: FYIcenter.com

A

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

⇑ CREATE, ALTER and DROP Statements in MySQL

⇑⇑ MySQL Database Tutorials

2018-03-04, 1238👍, 0💬

Rename an Existing Column in a Table in MySQL
How To Rename an Existing Column in a Table in MySQL? If you have an existing column in a table and you want to change the column name, you can use the "ALTER TABLE ... CHANGE" statement. This statement allows you to change the name of a column, and its definition. The tutorial script below gives yo... 2018-03-04, 1397👍, 0💬

Show CREATE TABLE Statements of Existing Tables in MySQL
How To See the CREATE TABLE Statement of an Existing Table in MySQL? If you want to know how an existing table was created, you can use the "SHOW CREATE TABLE" command to get a copy of the "CREATE TABLE" statement back on an existing table. The following tutorial script shows you a good example: mys... 2018-03-04, 1309👍, 0💬

Add a New Column to an Existing Table in MySQL
How To Add a New Column to an Existing Table in MySQL? 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 COLU... 2018-03-04, 1308👍, 0💬

Creating New Tables with SELECT Statements in MySQL
How To Create a New Table by Selecting Rows from Another Table in MySQL? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "CREATE TABLE ... SELECT" statement. The tutorial script below gives you a good... 2018-03-04, 1308👍, 0💬

Show All Indexes of a given Table in MySQL
How To Get a List of Indexes of a Given Table in MySQL? If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutorial script below shows you a nice example: mysql> SHOW ... 2018-02-14, 1290👍, 0💬

Delete an Existing Column in a Table in MySQL
How To Delete an Existing Column in a Table in MySQL? 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 ... 2018-03-04, 1239👍, 0💬

Show All Tables in a Database in MySQL
How To Get a List of All Tables in a Database in MySQL? If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example: mysql> SHOW TABLES; +---------------+ | Tables_in_fyi | +---... 2018-03-10, 1224👍, 0💬

Create an Index for a Given Table in MySQL
How To Create an Index for a Given Table in MySQL? If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an index, you can use the "CREATE INDEX" statement ... 2018-02-14, 1186👍, 0💬

Drop an Existing Table in MySQL
How To Drop an Existing Table in MySQL? If you want to delete an existing table and its data rows, you can use the "DROP TABLE" statement as shown in the tutorial script below: mysql> SELECT * FROM tipBackup; +----+-------------+---------- ---------------+-------------+| id | subject | descri... 2018-02-14, 1156👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.