fightbulc / simplon_mysql

MySQL PDO Wrapper (php, mysql, pdo, crud, library)
70 stars 22 forks source link

Column names are not backquoted #8

Closed scamhaji closed 8 years ago

scamhaji commented 8 years ago

If you try to update a row containing a column name which is a MySQL reserved word (for example left), it will fail (the same for delete, insert, insertMany, replace and replaceMany). All column names should be backquoted to avoid such situation. See https://dev.mysql.com/doc/refman/en/keywords.html