I am trying to load grahpics into a blob in my database. All the examples I've found use "INSERT" to do it. Since I already have a record created shouldn't I use "UPDATE?" I'm not sure I understand the difference. I think "INSERT" creates a new row, correct? Also, it appears there is nothing special about puting a graphic into a blob and can be done like any other peice of data:
update table mytable set myblob='<a very long string of data that is an entire jpg file>' where something='some value';
Is that correct?
Also, I'm having trouble figuring out the max size of a "mediumblob" from the documentation.
TIA.
update table mytable set myblob='<a very long string of data that is an entire jpg file>' where something='some value';
Is that correct?
Also, I'm having trouble figuring out the max size of a "mediumblob" from the documentation.
TIA.