tailieunhanh - Mysql your visual blueprint for creating open source databases- P15

Mysql your visual blueprint for creating open source databases- P15:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database. | MYSQL COMMAND REFERENCE B ADMINISTRATIVE COMMANDS MySQL includes a variety of administrative commands for managing tables processes users and various server components. OPTIMIZE TABLE The OPTIMIZE TABLE command sorts a table s index files and reclaims any space used by deleted rows. To use this command specify the table name. Example OPTIMIZE TABLE address CHECK TABLE The CHECK TABLE command checks a table for errors. Specify a table name and optionally one or more of the keywords QUICK FAST CHANGED MEDIUM or EXTENDED. Example CHECK TABLE address REPAIR TABLE The REPAIR TABLE command attempts to repair a damaged table. You can optionally specify the keywords QUICK for a fast scan or EXTENDED for a more thorough scan. ANALYZE TABLE The ANALYZE TABLE command analyzes a table s content and configures its keys for use in future queries. To use this command specify the table name. FLUSH HOSTS The FLUSH HOSTS command clears the host cache tables MySQL uses to manage access by users from remote hosts. This allows access by users who were previously blocked due to connection errors. FLUSH LOGS This command closes and reopens the MySQL log files. It is useful if you have changed logging settings or if you are backing up or deleting old data in the log files. FLUSH PRIVILEGES This command reloads the MySQL grant tables used to control access by users. This is useful if you have made changes to the tables manually. FLUSH QUERY CACHE This command arranges MySQL s cache of queries in memory to conserve memory. Use the command RESET QUERY CACHE to clear this cache completely. FLUSH TABLES This command closes and reopens all MySQL tables and clears the query cache. FLUSH STATUS This command resets most of the status variables that are shown with the SHOW STATUS command. These variables are also cleared each time you start the MySQL server. KILL This command stops a thread on the MySQL server. Specify the process ID number available from the output of SHOW PROCESSLIST. Example .