• 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

javascript ubuntu opensource sql macosx administration debian download function optimization development database performance windows mysql tricks configuration installation uml php gearman library tools web linux install python tips security 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?