MySQL Database
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
EXPLAIN PLAN.Learn how to work with MySQL string comparisons
Learn how you can use or ignore the pseudo
dual tableLearn 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 KEYLearn how to merge data with
REPLACE INTO statementLearn how to
MERGE into multiple tables with outer joinsLearn how to work with a Boolean data type or
TINYINTLearn how to work with the
GROUP BY clauseLearn 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.
Subscribe via RSS