Hisseine,
Thursday, April 11, 2002, 5:21:09 PM, you wrote:
HD> Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
HD> If yes which API can use to do these operations? (MySqL++)?
BLOB are just the same thing as other field types. You can use
INSERT, UPDATE, DELETE statements to work with tables that has
BLOB fields. You can read about BLOB types at:
http://www.mysql.com/doc/B/L/BLOB.html
To add file to the BLOB column you can use LOAD_FILE() function, look
at:
http://www.mysql.com/doc/S/t/String_functions.html
If you don't use LOAD_FILE don't forget to escape special chars in
your query. See http://www.mysql.com/doc/S/t/String_syntax.html for
more info about strings and blobs.
In the MySQL++ documentation you can find example how to load binary
file to a BLOB column, look at:
http://www.mysql.com/documentation/mysql++/4_Tutorial.html#SECTION03161000000000000000
HD> Thanks for help
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
