Topics

• Creating databases
• Table Creation
• INSERT
• Error codes
• Stored routines (procedures and functions)
• DELETE
• Indexes and Keys
• Date and Time Operations
• Joins
• UPDATE
• JSON
• SELECT
• ADO.NET
• Data Types
• Events
• Arithmetic
• Log files
• Clustering
• Backticks
• PDO

Examples

• Table creation with Primary Key
• Table creation with Foreign Key
• INSERT, ON DUPLICATE KEY UPDATE
• Multi-Table Deletes
• Show Table Structure
• Create Procedure with a Constructed Prepare
• Date arithmetic
• Update with Join Pattern
• SELECT with LIKE (%)
• Executing SQL statements as a command
• SELECT with DISTINCT
• Error code 1215: Cannot add foreign key constraint
• Create database, users, and grants
• INT as AUTO_INCREMENT
• Create an Event
• Introduction (numeric)
• Integer Types
• Fixed Point Types
• Floating Point Types
• Bit Value Type
• Slow Query Log
• General Query Log
• Error Log
• Backticks usage
• DATE, DATETIME, TIMESTAMP, YEAR, and TIME