Re: empty_blob() equivalent

2004-07-20 Thread Jeyabalan Murugesan Sankarasubramanian
msjeyabalan In the last episode (Jul 20), Jeyabalan Murugesan Sankarasubramanian said: Is there any equivalent of empty_blob() in mysql. Kindly guide us in this regard. Thanks in advance. You didn't tell us what empty_blob() is supposed to do. If empty_blob() checks to see whether a blob

empty_blob() equivalent

2004-07-19 Thread Jeyabalan Murugesan Sankarasubramanian
Hi All, Is there any equivalent of empty_blob() in mysql. Kindly guide us in this regard. Thanks in advance. regards msjeyabalan ** CONFIDENTIAL INFORMATION ** This e-mail transmission and any attachments may

Sql Query Issue

2004-07-12 Thread Jeyabalan Murugesan Sankarasubramanian
Hi All, I migrated the data from Oracle to MySQL.The following query works fine with Oracle whereas in MySql its hanging. SELECT distinct caty.name, caty.c_id, caty.notes, count(distinct segs.in_id) as num FROM segs, caty, st_mbers, t_mbers, p_mbrs, pr_mbers where segs.c_id = caty.c_id and