Hi,
just try like:
mysql> create procedure mi()
-> begin
-> declare done int default 0;
-> declare table_name varchar(50);
-> declare cur1 cursor for select tables.table_name from
information_schema.tables where table_schema='test' and table_type='BASE
TABLE' and engine='MyISAM';
y of handling conditional statements in MySQL?
> -Original Message-
> From: Trelfa, Jonathon [mailto:[EMAIL PROTECTED]]
> Sent: 04 March 2002 16:34
> To: [EMAIL PROTECTED]
> Subject: RE: Dynamic SQL
>
>
> Try using something a little different:
>
> if (
Try using something a little different:
if ($surname_all){ //checks to see if the variable is set
$surname_query = "WHERE surname between $surname_from and $surname_to";
} else {
$surname_query = "";
}
-Original Message-
From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Monday, Mar
