Note: This applies specifically to MySQL. In PostgreSQL for example, this is not an issue. If you care about performance...

If you want to have an English Ubuntu UI, but still see dates, money amounts, paper formats, etc. in German...

When storing floating-point numbers such as prices or totals in an SQL database, always use a DECIMAL column. Never...

Note: For PostgreSQL you should use advisory locks. For MySQL we still recommend the solution in this card.

CONCAT('foo', 'bar', NULL) = NULL the NULL always wins in MySQL. If you would rather treat NULL as...