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

This article mainly introduces the method of changing the column name in MySQL, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

If you have created the MySQL database and decided to delete it and add a replacement after one of the column naming errors, you can simply rename it.

Rename database column

In MySQL, you can use the ALTER TABLE and CHANGE commands to rename columns together to change existing columns. For example, suppose the column is currently named Soda, but you think Beverage is a more appropriate title. The column is in a table named Menu.

Here is an example of how to change:

ALTER TABLE menu CHANGE soda beverage varchar (10)

In the general form, you can insert your criteria into:

ALTER TABLE tablename CHANGE oldname newname varchar (10)

About VARCHAR

The VARCHAR (10) in the example can be changed to a column that suits you. VARCHAR is a variable length string. The maximum length (in this case, 10) represents the maximum number of characters to store in the column. VARCHAR (25) can store up to 25 characters.

Other uses of ALTER TABLE

The ALTER TABLE command can also be used to add a new column to a table or to delete an entire column and all its data from the table. For example, to add a column using:

ALTER TABLE table_nameADD column_name datatype

To delete a column, use:

ALTER TABLE table_nameDROP COLUMN column_name

You can also change the size and type of columns in MySQL.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the method of changing the list in MySQL. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.