|
我们可以通过使用 DROP 语句和 ALTER 语句从 MySQL 表中删除特定的现有列。其语法如下 - 语法ALTER TABLE table_name DROP column_name; 登录后复制 这里，table_name是我们要从中删除列的表的名称。 Column_name是要从中删除列的列的名称。将从表格中删除。 示例在此例如，我们从表“student_detail”中删除“address”列，如下所示 - mysql> select * from student_detail;
+-----------+-------------+----------+
| Studentid | StudentName | address |
+-----------+-------------+----------+
| 100 | Gaurav | Delhi |
| 101 | Raman | Shimla |
| 103 | Rahul | Jaipur |
| 104 | Ram | Ludhiana |
| 105 | Mohan | Patiala |
+-----------+-------------+----------+
5 rows in set (0.19 sec)
mysql> ALTER TABLE student_detail DROP address;
Query OK, 0 rows affected (1.43 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from student_detail;
+-----------+-------------+
| Studentid | StudentName |
+-----------+-------------+
| 100 | Gaurav |
| 101 | Raman |
| 103 | Rahul |
| 104 | Ram |
| 105 | Mohan |
+-----------+-------------+
5 rows in set (0.00 sec) 登录后复制 上面的结果集显示“address”列已从表中删除。 |
