MySQL utility commands
Posted December 30th, 2009 in MySql
This post is a summary of MySQL posts from this blog relating to MySQL utility commands, such as describing table structure, dropping columns from a table, and so on; and server settings.
Table maintenance
- Renaming a table in MySQL
- Rename multiple tables in MySQL
- Reset the auto increment value for a MySQL table
- Optimize a table in MySQL from the command line interface
- Check if a MySQL table exists
Copying tables
Listing tables and table structure
- Listing tables and their structure with the MySQL Command Line Client
- Get a MySQL table structure with DESCRIBE
- Get a MySQL table structure from the INFORMATION_SCHEMA
Indexes
Storage engines
- How to tell which storage engine a MySQL table uses
- How to change the storage engine a MySQL table uses
- Find which tables use INNODB with MySQL
- Use one file per table with MySQL's INNODB storage engine
Server Settings
- How to update the max_connections setting in MySQL
- How to enable remote access to a MySQL database server
- Change the full text index minimum word length with MySQL
Logging
Dropping columns, tables and databases
- How to drop a database with MySQL
- How to drop a table with MySQL
- Drop multiple MySQL tables
- MySQL: SQL to drop a column from a table

Comments
blog comments powered by Disqus