Syntax for input parameters in a MySQL query

Question

We recently switched a database from MSSQL to MySQL and the queries that use parameters don't work anymore.

Here's an example of a query in MSSQL:

SELECT * FROM users u WHERE u.ID = :id

Normally, the parameter browser would popup and ask me for a value for :id, but in MySQL I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':id'

I tried using a @ or ? instead of : and those do not work either.

ajreal · Accepted Answer · 2011-09-06 18:43:31Z

40

syntax is not the same

set @id:=123;
SELECT * FROM users u WHERE u.ID = @id;

answered Sep 6, 2011 at 18:43

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1