Setting up mysql proxy (windows)

Sometimes you need to view the exact query that your client sent to the server. For example, if you don’t know how PDO binds and escapes params or you’re using ORM. There is mysql proxy utility to facilitate this. So in order to install it you should: 1. Download the distribution from … 2. You don’t need to install anything. Just launch

Elance ANSI SQL code test with answers

Hi all, recently I tried to pass elance sql code test and managed to reply to only 8 out of 10 questions. I sent expert rating a feedback after the first pass as I believe limits should be allowed (however, maybe they are not in ANSI, I don’t remember). Anyway, here are the questions and my answers: 1. Consider a table named “salary” having the…

Removing duplicate rows in MySQL

Getting rid of duplicate table rows in mysql seems to be a very often issue. And there are few well-known solutions like e.g. creating temporary table and copying there only unique ones with group by and then drop the old and rename the newly one. But this solution is bad because we lose auto_increment counters and we might not have all grant privileges to do…

Page 1 of 1