MySQL How-To Guides

Practical MySQL answers with statements you can copy and run.

• How to Delete Rows in MySQL
• How to Rename a Table in MySQL
• How to Duplicate a Table in MySQL
• How to Add a Column in MySQL
• How to Rename a Column in MySQL
• How to Drop a Column in MySQL
• How to Insert Data in MySQL
• How to Update Rows in MySQL
• How to Create a View in MySQL
• How to List Tables in MySQL
• How to Truncate a Table in MySQL
• How to Change a Column Type in MySQL
• How to Upsert in MySQL (INSERT ... ON DUPLICATE KEY UPDATE)
• How to Get the Current Date and Time in MySQL
• How to Use GROUP_CONCAT in MySQL
• How to Describe a Table in MySQL
• How to Show Databases in MySQL
• How to Create a Database in MySQL
• How to Create an Index in MySQL
• How to Show Indexes in MySQL
• How to Add a Primary Key in MySQL
• How to Add a Foreign Key in MySQL
• How to Find Duplicate Rows in MySQL
• How to Remove Duplicate Rows in MySQL
• How to Limit Rows in MySQL
• How to Use CASE Statements in MySQL
• How to Concatenate Strings in MySQL
• How to Format Dates in MySQL
• How to Show CREATE TABLE in MySQL
• How to Kill a Query in MySQL

Running MySQL queries as a team? See the SaturnSQL MySQL editor.