Category Archives: SQL

WordPress: Diagnosing “Error establishing a database connection”

I recently experienced the ever-so-helpful “Error establishing a database connection” message from my WordPress installation.  After about 30 minutes looking through Google results and watching some terribly useless YouTube videos, the best explanation I found was: there must be a … Continue reading

Posted in PHP, SQL, WordPress | Leave a comment

SQL query to find duplicate rows, in any table

I recently needed a SQL query that could find duplicate rows in any table, without specifying each column.  With some help from Tom H., I have a solution.  And with some modifications, a foray into dynamic SQL and a stored … Continue reading

Posted in SQL | Tagged , , , | Leave a comment