how insert a file into a mysql database ?

[nicocl]

how insert a file into a mysql database ?
Which type should I use ? with which attributs ? (binary) ?
How create my sql request ?
I try :
ALTER TABLE `user` ADD `certificat` VARCHAR BINARY NOT NULL
without any succes.
Error : You have an error in your SQL syntax near 'BINARY NOT NULL' at line 1

Thanks for your help

Nicolas

 

[williamu]

Hi,
You'll need to give the VARCHAR a length. E.G. VARCHAR(512) etc.

If this is a file you want to store you'll need to use the BLOB type, but it's not as easy as it looks. Getting the Data back out can be quite tricky.



William
Software Engineer
ICQ No. 56047340

 

[sleipnir214]

I recommend that you store the name of the file in the database and store the actual contents of the file on your filesystem. As williamu has said, manipulating BLOB data is not easy.

Also, if you are creating a web-based application that will serve out those files, then you will have to write the code to fetch the file, set the correct content-type, and stream out the file. If you store the file on the filesystem, your web server already has code built in to do all that.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!