Topics

• Variables
• Limit and Offset
• Creating databases
• Backup using mysqldump
• JSON
• Table Creation
• INSERT
• Error codes
• Stored routines (procedures and functions)
• String operations
• DELETE
• VIEW
• Indexes and Keys
• Date and Time Operations
• Comment Mysql
• LOAD DATA INFILE
• PREPARE Statements
• ALTER TABLE
• Joins
• UPDATE
• Change Password
• PHP MySQLi
• JSON
• MySQL Admin
• Configuration and tuning
• Converting from MyISAM to InnoDB
• SELECT
• Create New User
• Group By
• UNION
• Drop Table
• Data Types
• Performance Tuning
• ENUM
• Arithmetic
• Lists
• Character Sets and Collations
• MyISAM Engine
• Many-to-many Mapping table
• Log files
• Partitioning
• Clustering
• Security via GRANTs
• Image Processing with GD
• MySQL LOCK TABLE
• MySQL Unions
• ORDER BY
• MySQL client
• Mysql Performance Tips
• Temporary Tables
• Transaction
• NULL
• Connecting with UTF-8 Using Various Programming language.

Examples

• echo and print
• Specifying username and password
• Encoding a JSON string
• Table creation with Primary Key
• Table creation with Foreign Key
• INSERT, ON DUPLICATE KEY UPDATE
• Error code 1064: Syntax error
• Inserting multiple rows
• Create a Function
• Create a View
• PREPARE, EXECUTE and DEALLOCATE PREPARE Statements
• Changing storage engine; rebuild table; change file_per_table
• Show Table Structure
• Basic Update
• InnoDB performance
• Basic conversion
• Date arithmetic
• Testing against a date range
• SELECT all columns (*)
• SELECT with LIKE (%)
• SELECT with Alias (AS)
• Create a MySQL User
• Group By Using MIN function
• SELECT with a LIMIT clause
• JOIN with subquery ("Derived" table)
• DELETE vs TRUNCATE
• MySQLi Insert ID
• GROUP BY USING COUNT Function
• GROUP BY using HAVING
• ORDER BY
• Pagination via OFFSET
• SELECT with DISTINCT
• Construct and execute
• VARCHAR(255) -- or not
• INT as AUTO_INCREMENT
• Others
• Add the correct index
• Set the cache correctly
• Avoid inefficient constructs
• Negatives
• Cursors
• AUTO_INCREMENT key
• Why ENUM?
• TINYINT as an alternative
• VARCHAR as an alternative
• Adding a new option
• Arithmetic Operators
• Mathematical Constants
• Trigonometry (SIN, COS)
• Rounding (ROUND, FLOOR, CEIL)
• Random Numbers (RAND)
• Introduction (numeric)
• Fixed Point Types
• Floating Point Types
• Bit Value Type
• Array as list
• Lists can be passed into subroutines
• Declaration
• Connection
• Which CHARACTER SET and COLLATION?
• Backup direct to Amazon S3 with compression
• ENGINE=MyISAM
• Typical schema
• Return list from subroutine
• SELECT with CASE or IF
• A List
• Slow Query Log
• Multi-table DELETE
• Disambiguation
• Best Practice
• Host (of user@host)
• Using arrayref to pass array to sub
• 1045 Access denied
• 1236 "impossible position" in Replication
• 2002, 2003 Cannot connect
• 1067, 1292, 1366, 1411 - Bad Value for number, date, default, etc.
• 126, 127, 134, 144, 145
• 139
• 1366
• 126, 1054, 1146, 1062, 24
• CHAR(n)
• Mysql Locks
• Tranferring data from one MySQL server to another
• Union operator
• LENGTH()
• CHAR_LENGTH()
• HEX(str)
• NULL vs NOT NULL
• MyDatabase
• System Databases
• Contexts
• Basic
• ASCending / DESCending
• Some tricks
• Atomic RENAME & Table Reload
• Updating a table via a VIEW
• Renaming a MySQL database
• Retrieve customers with orders -- variations on a theme
• INSERT with AUTO_INCREMENT + LAST_INSERT_ID()
• Commenting table definitions
• Lost AUTO_INCREMENT ids
• Create Temporary Table
• Start Transaction
• Optimizing Storage Layout for InnoDB Tables
• Multiple ResultSets
• Uses for NULL
• Testing NULLs
• Create a function
• Row Level Locking
• Python
• PHP
• Building a composite index
• SELECT with date range