• Database Management Systems

• MS SQL Server
• MySQL
• Oracle Berkeley DB

• Libraries

• Apache Portable Runtime
• Apache Portable Runtime Utility
• Flex
• Freetds
• Libiconv
• Libmcrypt
• Libmhash
• Libpng
• Libxml
• Libxslt
• m4
• Neon (webdav)
• OpenSSL
• zLib

• Miscellaneous

• Bison
• Byacc
• UML
• Varnish Cache

• Operating Systems

• Linux
• MacOS X
• MS Windows

• Servers

• Apache Web Server
• Internet Information Services
• Node.js
• vsftpd FTP Server

• Tools

• Development
• Security

• Web Development

• AJAX
• Javascript
• PHP
• Python

source-code php tools windows performance optimization configuration ubuntu javascript python web tricks security macosx function linux download gearman development administration uml installation library tips mysql database sql install opensource debian

Home > Tutorials > Database Management Systems > MySQL > Tips And Tricks

• How to delete rows in table when PK is referenced in another table
• Unique primary keys(PKs) for MySQL using Redis
• Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
• Fast, parallel restore from SQL dumps (mysqldump) for MySQL
• MySQL DATE_FORMAT function and ORDER BY
• MySQL Query Cache not necessarily a bad thing
• Not-so-well-known differences between MyISAM and Innodb MySQL server storage engines
• MySQL unique key vs primary key constraints
• MySQL query to find all views in a database
• How to find all tables of a particular storage engine in MySQL?
• How to find MySQL server uptime?
• SQL: Union and Union All
• How to see table definition statements in MySQL?
• How to find if MySQL supports partitioning or not?
• Transfering MySQL Administrator/Query Browser connection details
• How to check MySQL version number?