Thread: BLOB data-type

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    chennai, tamil nadu, INDIA
    Posts
    27
    Rep Power
    0
    what is the syntax of BLOB data type. kindly give one example.
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    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/m...ence.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 *
    *************************************************************

Similar Threads

  1. SQL Server image data type
    By cf_greg in forum ColdFusion Development
    Replies: 5
    Last Post: October 18th, 2006, 09:01 PM
  2. Codepupil
    By Adachic in forum C Programming
    Replies: 3
    Last Post: February 6th, 2004, 06:50 PM
  3. [urgent]C programming: data type conversion
    By bythesea in forum C Programming
    Replies: 5
    Last Post: January 18th, 2004, 09:34 AM
  4. Handling large data for Long or CLOB data type
    By priyendu in forum Perl Programming
    Replies: 2
    Last Post: January 7th, 2004, 05:52 AM
  5. my comp sux lately , need help from pro's
    By Hykinsel007 in forum Windows Help
    Replies: 2
    Last Post: January 5th, 2004, 01:52 PM

IMN logo majestic logo threadwatch logo seochat tools logo