I have a simple stored procedure which works as intended.
As soon as I add a UNION in the SELECT I get the error message
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'select phon_Lvl INTO Lvl
Are UNION's currently not allowed in a stored procedure?
mysql> delimiter //
mysql> create procedure ph()
-> BEGIN
-> DECLARE LVL Char(10);
-> select phon_Lvl INTO Lvl
-> FROM phones
->
-> limit 1;
-> SET @Lvl:=Lvl;
-> END//
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql>
mysql> call ph();
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> Select @Lvl;
+------+
| @Lvl |
+------+
| locn |
+------+
1 row in set (0.00 sec)
mysql>
mysql> drop procedure if exists ph;
Query OK, 0 rows affected (0.01 sec)
mysql> delimiter //
mysql> create procedure ph()
-> BEGIN
-> DECLARE LVL Char(10);
-> select phon_Lvl INTO Lvl
-> FROM phones
-> UNION
-> Select "a" into LVL
-> limit 1;
-> SET @Lvl:=Lvl;
-> END//
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'select phon_Lvl INTO Lvl
FROM phones
UNION
Select "a" into LVL
limi' at line 4
mysql> delimiter ;
mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
