mySQL Database

[Marki]

Hi,

Does anyone know about mySQL database?!
I need to know how to store images (ie. Picture) and files (ie. Power Point presentation) in a table that I created on mySQL database. The images and files are in 'My Document' directory.

Cheers for the help.

Marki

[PeOfEo]

Do you want users to be alble to access these image or do you want to add to it over the net? You will need to access the data base, I suggest asp or asp.net to do this

[Nedals]

I would not suggest you save images, presentations, etc. to a database. Instead save your files to a directory on your server (maybe non-web accessible depending what you are doing) and then save the path and filename to the database.

[DaiWelsh]

I agree with nedals, RDBMSs like MySQL are optimised for storing various types of data like text, numbers, dates etc. Generally they are not optimised or even suited for storing large binary objects like image files, powerpoint files etc. Your file system (or the file system on your web server) is basically a database system designed for storing files, so better to use that :)