MySQL query parameters

[NearAway]

Hello everyone,

I'm a sql server DBA and I'm new to MySQL. I'm using version 4.0 (with no stored procs).

What I would like to know is how queries with parameters are performed, ie:

SELECT *
FROM table
WHERE field1 = 'some value'

The impression I'm getting is that MySQL 4.0 must have complete statements passed into it. In other words, the statement is created in a front end app like asp or C or whatever and the parameters are appended and everything, then the whole statement is passed to MySQL for processing. There is no way to pass in a parameter or search value to MySQL.

Is this correct? Many thanks

Rick

 

[sleipnir214]

This is correct. On-the-fly parameters are generally handled by the user interface and its associated programs.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[hos2]

in the user interface you can add parameters to you're sql statement

$query="SELECT *
FROM table
WHERE field1 = '$yourvariable'";

if that's what you mean and otherwise it's way out of my knowledge

 

[NearAway]

Thanks guys!

take care

Rick