WHERE id = UNHEX('36a461c81cab40169791f49ad65a3728')
-Original Message-
From: Martin Koch [mailto:m...@issuu.com]
Sent: Tuesday, April 30, 2013 8:18 AM
To: mysql@lists.mysql.com
Subject: Long integer constant problem in views
Hi List
I have a table with a primary key with
2013/04/30 17:17 +0200, Martin Koch
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
Try this: _binary X'36a461c81cab40169791f49ad65a3728'
SHOW CREATE VIEW is the command for the client.
--
MySQL General Mailing List
For list