MySQL Common statements

？ Contents View Help

Show [globle|session] status; View Run status

Show [globle|session] variables [like condition]; View Configuration Items

Load data infile path into tablename; Import data from a file

Select Columnlist from tablename to outfile path; Export columns from a specified table to an external file

Check table tablename; Check table

Optimize table tablename;//Optimization tables

Rename table TableName to New_tablename; Modifications indicate

CREATE table new_tablename like old_tablename; Copying tables

CREATE TABLE New_tablename select * from Old_tablename; Copying table data

MySQL Common statements