Articles tagged with mysql

Installing CakePHP on MacOS X.

By Giovanni Glass
This is how I setup CakePHP on my MacBook with PHP5 and MySQL5. I have MacOS X 10.4.8 installed.
[Read more]

Detecting duplicate entries when updating

By Ben XO
Cake doesn't tell you the difference between an Model->save() that fails because of a validation error, and one that fails because of key constraint violation (that is, a duplicate entry). Here, I will show you an easy way to overcome this. (MySQL specific)
[Read more]

Obvious trick to reduce amount of HABTM relationship tables

By Sergey Egorov
Trick howto reduce amount of HABTM tables in complex application
[Read more]

MySQL collation behavior

By Pawel Gasiorowski
A simple behavior that sets proper collation for order by SQL statements based on the current localization.
[Read more]