Parameterized Query

noun

say it: “puh-RAM-ih-ter-yzd KWEER-ee” /pəˈræmɪtəraɪzd ˈkwɪəri/

A query where values are sent separately as parameters like @id, instead of being pasted into the SQL text.

What is Parameterized Query in a relational database?

Parameterized Query — A query keeping data values separate from SQL text through parameters.

SELECT customer_id, email
FROM customer
WHERE email = ?;

In a sentence

  • “A parameterized query sends the city as @City, so nothing the user types can change the SQL.”

Level: Journeyman · More Database terms at this level

Updated