Re: empty_blob() equivalent

2004-07-19 Thread Jeyabalan Murugesan Sankarasubramanian
l. regards 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

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 co

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 caty