List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 20 2004 5:51am
Subject:Re: empty_blob() equivalent
View as plain text  
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 is empty:

  SELECT .... WHERE myblob = '';

If empty_blob() zeroes out a blob:

  UPDATE ... SET myblob = '';

blobs are just large varchars, basically.

-- 
	Dan Nelson
	dnelson@stripped
Thread
empty_blob() equivalentJeyabalan Murugesan Sankarasubramanian20 Jul
  • Re: empty_blob() equivalentDan Nelson20 Jul
Re: empty_blob() equivalentJeyabalan Murugesan Sankarasubramanian20 Jul
  • Re: empty_blob() equivalentDan Nelson20 Jul