Shulou(Shulou.com)05/31 Report--

This article mainly introduces mysql how to modify the field type, the article is very detailed, has a certain reference value, interested friends must read it!

In mysql, you can use the "ALTER TABLE table name MODIFY [COLUMN] field name data type length default value comment;" statement to modify the field type. This statement can modify not only the field type, but also the type length, default value, and comments.

To modify the type, use the SQL statement

Alter table table name alter column field name varchar not null

Example:

The new table is shown in the following figure:

Change the name column varchar with a length of 20, as shown below:

After the change, the result is:

The above is all the content of the article "how to modify field types in mysql". Thank you for reading! Hope to share the content to help you, more related 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.