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
Server information
Share or Bookmark
Share or Bookmark this page using the following services. You will need to have an account with the selected service in order to post links or bookmark this page.
Subscribe or Follow
Subscribe via RSS or email, or follow me on Facebook or Twitter below. The RSS icon takes you through to Feedburner where you can select the service or application to use.
RSS Feed
Facebook
Twitter
By Email