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

Editor to share with you how to write the sql deletion column sentence in mysql, I believe most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Mysql's sql delete column statement is: 1, add calumn, the code is [alter table actor drop column last_name]; 2, do not add calumn, the code is [alter table actor drop last_n].

The sql delete column statement for mysql is:

There is already a table actor with column last_name

Delete columns in either of the following ways

Alter table actor drop column last_name;alter table actor drop last_name

To add a column, you must specify the type of column

Alter table actor add last_name varchar (10); the above is all the content of how to write the sql delete column sentence in mysql, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.