Topics

• Creating databases
• Backup using mysqldump
• Error codes
• DELETE
• VIEW
• UPDATE
• Converting from MyISAM to InnoDB
• SELECT
• Drop Table
• MySQL LOCK TABLE
• Temporary Tables
• Transaction
• Replication

Examples

• Drop Table
• 126, 127, 134, 144, 145
• 126, 1054, 1146, 1062, 24
• Converting All Tables in one Database
• Create Temporary Table
• Drop Temporary Table
• Start Transaction
• COMMIT , ROLLBACK and AUTOCOMMIT
• Transaction using JDBC Driver
• UPDATE with ORDER BY and LIMIT
• Multiple Table UPDATE
• Master - Slave Replication Setup
• Replication Errors
• Row Level Locking