• 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

php administration macosx web performance development install tools installation security windows library python http configuration uml download tips gearman database debian opensource optimization javascript linux sql ftp ubuntu mysql module

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?