Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Syntax for input parameters in a MySQL query

Tags:

sql

mysql

We recently switched a database from MSSQL to MySQL and the queries that uses parameters does'nt 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 this 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 it does'nt work.

Thanks in advance for the help.

like image 878
Simon Avatar asked Sep 06 '11 18:09

Simon


People also ask

What is the syntax of MySQL database query?

Syntax: SELECT [COLUMN NAMES] FROM [TABLE NAME] WHERE [CONDITION] AND [CONDITON]; Example: SELECT EMP_NAME, FROM EMPLOYEE WHERE EMP_ID=200 AND EMP_COUNTRY=”INDIA”; 5. OR: This MySQL Query Command combines the data from the table for the specific condition.

What is a parameter in MySQL?

In general, a parameter is a placeholder for a variable that contains some value of some type when executing a general-purpose query, or arguments and return values when a stored procedure is executed. Parameter is represented by MySql.


1 Answers

syntax is not the same

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

Docs for User defined variables

like image 187
ajreal Avatar answered Oct 03 '22 12:10

ajreal