1. Modify the table name: alert table oldtablename rename newtablename; or alert table oldtablename rename to newtablename;
[graphical interface If you use it too much, alter will always be typed into alert]
2. Add a field column at the end of the table: alter table tablename add attribute name attribute type;
3. Add fields in the first column of the table: alter table tablename add attribute name attribute type first;
4. Specify fields in the table Add fields later: alter table tablename add attribute name attribute type after attribute name;
## The above is mysql Commonly used basic operation syntax (2)~~Add, delete, and modify operations on tables [command line mode]. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!