I have column named key which is a reserved word in MySQL.
If you don't use a backtick ``` in you SQL query then will error.
My SQL that was build by this library was SELECT * FROM secure_holiday_feature WHERE key = '2' which didn't give any result.
This one did SELECT * FROM secure_holiday_feature WHERE key = 2.
It also messes up the ->update() query.
Kind regads,
Jaime
I have column named
keywhich is a reserved word in MySQL.If you don't use a backtick ``` in you SQL query then will error.
My SQL that was build by this library was
SELECT * FROM secure_holiday_feature WHERE key = '2'which didn't give any result.This one did
SELECT * FROM secure_holiday_feature WHEREkey= 2.It also messes up the
->update()query.Kind regads,
Jaime