Using Php PDO Insert statement

Question

Someone told me that when you are working with PDO, you cannot use "INSERT INTO .... SET" to insert data into database, because it will not work on databases other than MySQL. I'm not sure what exactly he means, maybe he means I should use the other method of inserting like,

INSERT INTO table (column1, column2) VALUES (?, ?)

I tried searching on the internet for this, but I couldn't find anything. Please let me know about this.

Thank you.

Answer 1

You should use the INSERT INTO table (column1, column2) VALUES (?, ?) statement instead of the INSERT INTO table SET column1=? statement, because that's the correct syntax for SQL based database languages. Although MySQL accepts it, others may not.