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

This article mainly introduces MySQL how to modify the table and add fields, the article is very detailed, has a certain reference value, interested friends must read it!

MySQL modify table add field

Syntax:

Alter table table name

Add a field:

Alter table table name add field [column] data type [location]

Mysql > alter table user add tel varchar (11); / / No location defaults to the last mysql > alter table user add address varchar (50) after password; / / add mysql > alter table user add age int first; / / add all the contents of the article "how to modify tables and add fields in MySQL" after passwrod. 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.