Shulou(Shulou.com)06/01 Report--

This article is about how mysql deletes a field from a table. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Mysql method to delete a field in a table: you can delete a field in the table by executing the [alter table table name drop column field name;] statement.

Demand:

Delete a specific field from the table that has been built.

SQL command:

Alter table table name drop column field name

Thank you for reading! The method of deleting a field in the mysql table is shared here. I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.