Hello.
> ERROR 1314 (0A000): PREPARE is not allowed in stored procedures
PREPARE in the stored procedures should work in the latest release (5.0.18).
David Godsey wrote:
> Thank you. I tried this outside of the procedure and it works. However In
> MYSQL 5 I get:
> ERROR 1314 (0A000): PREPARE
Thank you. I tried this outside of the procedure and it works. However In
MYSQL 5 I get:
ERROR 1314 (0A000): PREPARE is not allowed in stored procedures
Is there a way without needing to use prepare?
Any idea why CAST(fdata AS UNSIGNED) doesn't work?
David Godsey
> Hello.
>
> You can use this
Hello.
You can use this technique:
drop procedure if exists test20;
DELIMITER $$
create procedure test20()
BEGIN
DECLARE fdata BLOB;
DECLARE foffset INT UNSIGNED;
DECLARE flength INT UNSIGNED;
DECLARE tmp_int BIGINT UNSIGNED;
SELECT 0xAB
