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 is
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
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
I am trying to convert binary data to a bigint so I can do bitwise
operations on the data, and I'm having trouble doing it.
I noticed that if I have binary data and I:
select data1; I get 0 (not what I'm expecting).
Here is a test procedure I wrote:
create procedure test20 ()
BEGIN
@lists.mysql.com
Subject: [SPAM] - convert help - Bayesian Filter detected spam
I am trying to convert binary data to a bigint so I can do bitwise
operations on the data, and I'm having trouble doing it.
I noticed that if I have binary data and I:
select data1; I get 0 (not what I'm expecting).
Here is a test
] - convert help - Bayesian Filter detected spam
I am trying to convert binary data to a bigint so I can do bitwise
operations on the data, and I'm having trouble doing it.
I noticed that if I have binary data and I:
select data1; I get 0 (not what I'm expecting).
Here is a test procedure I wrote
| hex(@fdata) |
++-+
| ââ©âº#E | CDEF012345 |
++-+
1 row in set (0.00 sec)
-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 3:33 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - convert help