MySQL – A simple script to truncate all MySQL tables in a Database
Want a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read moreMySQL – Best way to remove all data from a table
There are multiple ways in which to remove all data from a MySQL Table. The first is to use the DROP TABLE command, which will remove the entire table with…
Read moreTop My.CNF Optimizations for Innodb
These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb. If you are suffering from poor performance, try changing the…
Read moreMySQL – Should you put an index on a Boolean field to help query performance?
I am often asked if it makes sense to place an index on a Boolean field in order to improve query performance. In general, because a boolean value can only…
Read moreMySQL – DateTime vs. TimeStamp – When to use?
This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…
Read moreMySQL – SQL Injection, and how to Prevent it
SQL injection vulnerabilities are often been described as the most serious threat for Web applications, regardless of what language they are written in . Web applications that are vulnerable to…
Read more