If you’re in web development area, you certainly know about SQL injection attack. There is also a well-known joke about it on xkcd: There is a tool for automating SQL injection discovery, called sqlmap, you can find it on github
Category: MySQL
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 https://dev.mysql.com/get/Downloads/MySQ … oobly.com/ 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…