Using MySQL to maintain a database

• Retreiving data using the SELECT statement
• Using the AS clause for column aliases
• Using LIMIT clause
• Using the WHERE clause
• Using the WHERE clause with logicals
• Using the LIKE clause in a WHERE clause
• Sorting the result set
• Using the JOIN clause with multiple tables
• Aggregate functions
• Grouping the result set
• Using subqueries
• Inserting data
• Modifying data
• Deleting data

Back