2 ms·
> Prepared statements, by contrast, are also a form of string concatenation. And they have some understanding of type and syntax, but only because they learn th
by jimktrains2 12y ago
> Prepared statements, by contrast, are also a form of string concatenation. And they have some understanding of type and syntax, but only because they learn them from the server:
Prepared statements are NOT string concatenation. The server parses the SQL, creates what internal representation it does, and then uses the parameters more as arguments to that executable statement than checks them and sticks them in. At no point does a SQL statement exist with the parameters and SQL.