Feb 25

MySQL, all your charsets are belong to us

MySQL, Testing , , Add Comment (0)

Why does everything in MySQL have a charset/collation?
Read More



Feb 11

Stored procedures are evil

MySQL, PHP , , Add Comment (0)

Good (but old) article why not to use stored procedures in combination with PHP applications.
Read More



May 23

MySQL: find duplicate entries

MySQL , Add Comment (0)

Saved me a lot of time:

SELECT COUNT(*), column1, column2 FROM tablename
GROUP BY column1, column2
HAVING COUNT(*)>1;

Source: http://lists.mysql.com/mysql/204859



Apr 21

SQL Injections

MySQL , Add Comment (0)

Need to know for all developers…

Get a basic idea of how sql injections work: http://ferruh.mavituna.com/sql-injection-cheatsheet-oku



Oct 23

Hidden feature mysqldumpslow: order by count

MySQL , , Add Comment (0)

MySQL has a nice tool called ‘mysqldumpslow’. It parses and summarizes the MySQL slow query log.

An interesting tool, however in most cases you’ll want to solve slow queries which reoccur the most, thus sorting the slow query log by count.
Read More