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

This article is about how to use sql to add columns to a table in mysql. 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.

First select a data table, as shown in the following figure

Then create a new query, as shown in the following figure

Next, execute the add column statement, as shown in the following figure

Then the column is added directly, as shown in the following figure, by default at the end

If you want to add it to a specified location, you can add an after statement, such as after uname, as shown in the following figure

Finally, the new column is added after uname, as shown in the following figure

To sum up, in mysql to add new columns to the table is mainly through the add aolumn, you can specify the location.

Thank you for reading! On how to use sql in mysql to add columns to the table is shared here, I hope the above content can be of some help 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.