Archive for the 'mysql' Category


Alternative to phpMyAdmin MySQL Database Administration - Navicat

database, mysql, tools

If you need indexes, MySQL will EXPLAIN

database, indexes, mysql

MySQL Password Function - OLD_PASSWORD() and PASSWORD()

code, database, mysql, upgrades

Incorrect usage of UNION and ORDER BY

code, databases, dev, mysql

subquery workaround in MySQL 4

code, database, dev, mysql, php, sql, webdev

MySQL Random Row

code, database, mysql

Reseed MySQL Primary Key - AUTO_INCREMENT

code, database, mysql, webdev