Is it possible to upload files to mysql?
If so, how large can the file be.
Are there advantages/disadvantages to doing this?
Thanks
uploading to mysql
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
yes. read up on BLOB type: http://dev.mysql.com/doc/mysql/en/blob.html
A disadvantage is it requires you to make a database query for each one seperately. Another is increased overhead and work due to transfering the data out of mysql and then sending it to the client. If you want to store images, we'd suggest you store them in the file system and potentially store the filename for output to the browser.
A disadvantage is it requires you to make a database query for each one seperately. Another is increased overhead and work due to transfering the data out of mysql and then sending it to the client. If you want to store images, we'd suggest you store them in the file system and potentially store the filename for output to the browser.