query with parameter

dimis2500 · #1 (**permalink**) 05-13-08, 09:24

I use mysql command prompt and I use the query with parameter as oracle, meaning type

Code:

select a from mytable where a=@a

where @a I will give at command prompt when the prompt will ask for that, how can I do that?

dimis2500 · #2 (**permalink**) 05-13-08, 10:08

I find this

Code:

PREPARE stmt1 FROM 'SELECT * from `shop3` where dealer=?';
 SET @a = 'a';
 EXECUTE stmt1 USING @a;
 DEALLOCATE PREPARE stmt1;

How can I set the command promp to ask for the value?