Using MySQL

In this chapter, we will cover the following recipes:

• Connecting to MySQL using the command-line client
• Creating databases
• Creating tables
• Inserting, updating, and deleting rows
• Loading sample data
• Selecting data
• Sorting results
• Grouping results (aggregate functions)
• Creating users
• Granting and revoking access to users
• Selecting data into a file and table
• Loading data into a table
• Joining tables
• Stored procedures
• Functions
• Triggers
• Views
• Events 
• Getting information about databases and tables