Topics

• Backup using mysqldump
• Table Creation
• Indexes and Keys
• Pivot queries
• Arithmetic

Examples

• Basic table creation
• Cloning an existing table
• Create index
• Create unique index
• Creating a pivot query
• Arithmetic Operators
• Rounding (ROUND, FLOOR, CEIL)
• Tranferring data from one MySQL server to another