var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query with parameter
I use mysql command prompt and I use the query with parameter as oracle, meaning type
where @a I will give at command prompt when the prompt will ask for that, how can I do that?
select a from mytable where a=@a
I find this
How can I set the command promp to ask for the value?
PREPARE stmt1 FROM 'SELECT * from `shop3` where dealer=?';
SET @a = 'a';
EXECUTE stmt1 USING @a;
DEALLOCATE PREPARE stmt1;