BLOB data-type

what is the syntax of BLOB data type. kindly give one example.

CREATE TABLE test (my_blob blob);
INSERT INTO test VALUES ('Shove this up your blob');
SELECT my_blob FROM TEST;

Please read the manual.
http://www.mysql.com/documentation/...rence.html#BLOB

Next time, I'm just going to tell you RTFM. Ask around to figure out what it means.

---John Holmes...

------------------
*************************************************************
* The manual can probably answer 90% of your questions... *
* *
* PHP Manual. www.php.net/manual *
* MySQL Manual: www.mysql.com/documentation/mysql/bychapter *
*************************************************************