This links to my blog posts and pages dealing with using MySQL Server, and it includes material on versions 5.0, 5.1, and 6.0. The blog pages show below the top-level page in the right hand column, while blog posts only show in the list below.
MySQL Server ↓
A list of blog posts and pages dealing with the MySQL Database that are cross-platform issues.
Learn how to assign a query result to a local variable in a stored procedure.
Learn how to create an
Learn how to work with MySQL string comparisons
Learn how you can use or ignore the pseudo
Learn how to decode a MySQL 1005 error
Learn how to discover foreign keys in MySQL InnoDB tables
Learn how to write MySQL Persistent Stored Methods
Learn how to install, configure, and create a sample database and user.
Learn how to fix server authentication after a failed installation.
Learn how to export data from MySQL to a native CSV format.
Learn how to import data from MySQL to a native CSV format.
Learn how to merge data through
ON DUPLICATE KEY
Learn how to merge data with
Learn how to
MERGEinto multiple tables with outer joins
Learn how to work with a Boolean data type or
Learn how to work with the
Learn how to reset your MySQL user password
Learn how to work with MySQL Regular Expressions
Learn how to write Java the works with MySQL’s JDBC Driver
Learn how to write MySQL Procedures with DDL and DML Prepared Statements
Learn how to hide your MySQL password in a Windows command prompt
Learn how to use Quest’s Toad for MySQL
MySQL Server 5.1 ↓
A list of blog posts and pages dealing with MySQL 5.1 Database Server.
MySQL Server 5.5 ↓
A list of blog posts and pages dealing with MySQL 5.5 Database Server.
If you have suggestions for other concepts, post a comment.