Skip to content Skip to sidebar Skip to footer

Mysql Rejecting Parameter

Ok, I'm going crazy on this one. MySQL is throwing a fit about this bit of SQL: INSERT INTO `test_table` ( `column1`, `column2` ) VALUES ( ?COURSEID, ?COURSENAME ) You hav

Solution 1:

MySQL does not support named parameter placeholders. You can use only positional parameter placeholders. That is, a placeholder is just a ? symbol.

This conforms to the ANSI SQL behavior, by the way. RDBMS like Oracle support named parameters as an extension to the standard.

Post a Comment for "Mysql Rejecting Parameter"