• 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

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

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?