Tag Archives: SQL

Case Sensitive Comparisons in MySQL Where Clause

How can I make MySQL treat my query as case sensitive? As with all good tools there’s more than one way to get the job done. Assuming you have access to change the structure of the table you have to … Continue reading

Posted in Code Snippets, Database, MySQL, SQL Tagged , ,

Database error fix… mysqldump: Couldn’t execute show create table view

Today I found that my automated MySQL backups have been choking for the last few days with “mysqldump: Couldn’t execute show create table view” because I recently added a view to one of the databases. Apparently the backup user needs … Continue reading

Posted in Code Snippets, Database, MySQL, Server Administration Tagged , , , , ,