MySQL data table operations

1. Create table table name (name char), sex enum (' Male ', ' female '),..... ）；

2. View all tables in the database show tables from database name; 3. View column information in the table show colunms from table name; /desc table name; 4. Add a column ALTER TABLE user add password char () [After name/first];5. Modify column name and type ALTER TABLE name change old column name new column name data type; 6. Repair Change the type of the column ALTER TABLE name modify column name data type; 7. Modify the location of the column ALTER TABLE user modify column 1 type after column 2;8. Delete column ALTER TABLE table name drop column name; 9. Modify Tables Name ALTER TABLE old table name rename to new table name; 10. Delete Table drop tables Table 1, table 2, ...;

MySQL data table operations