• 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

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

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?