MySql + InnoDB + PHP Single Quote Discrimination?

Okay, I've recently converted a number of tables to the InnoDB storage engine and I've been getting errors whenever I use a single-quote ' i开发者_高级运维n the column list of the INSERT statement:

INSERT INTO 'Table' ('Col1', 'Col2') VALUES ('Val1', 'Val2')

When I tired using phpMyAdmin to generate a proper statement, it looked virtually the same, so I pasted it in my app, and it worked. Then my next statement had the same error so I started to get suspicious. After a bit of playing around I found that the problem was that the query needed a back-tick instead of single-quotes, but not for the whole thing.

INSERT INTO `Table` (`Col1`, `Col2`) VALUES ('Val1', 'Val2')

works, so it's not like MySql doesn't understand the single-quote. What is going on here? I also can't just leave the columns unquoted like before with MyISAM (ie: Table(Col1, Col2))

---

That's because single quotes denote string literals, whereas backticks denote database/table/column identifier escapes.

Removing backticks causes an error because TABLE is a reserved word, so in order to use it as a table name you have to include backticks.

---

You put single quotes around string values, and you use backticks around object names. The backticks are technically not necessary though unless that name of your table/column is a reserved word or has spaces/funny characters in it.