Count number of tables in the database – MySQL
Determining the number of tables that are contained in a MySQL database is very straight-forward, although it is an often asked question. The simplest way to accomplish this is using…
Read moreMySQL Delimiters – Or why I hate stored procedures and Error Code : 1064 You have an error in your SQL syntax.
MySQL 5.0+ gave DBA’s the ability to write stored procedures and functions. This is a great addition, and one that all “real” DB engines should provide. But, as many DBA…
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 moreMySQL – Disabling Binary Logging for INSERT and UPDATE
I have run into many situations where there would be a benefit to not replicate a large INSERT or UPDATE from the MASTER to SLAVE in order to not block…
Read moreMySQL – Constraints on Hierarchical Data in a Self-Referential Table
I recently had a client who was using a table structure that utilized a self-referential structure using an ID field and Parent_ID fields. After upgrading to Innodb, his DBA was…
Read moreMySQL How to delete duplicate records and rows of data
The fastest and easiest way to delete duplicate records is my issuing a very simple command. alter ignore table [tablename] add unique index `unique_index` ([fieldname]) What this does is create…
Read more