filter;sql;query
Hello folks
Can anyone pls give some useful tips for these questions
1.I have to store some images in the db. Each image size is around 800kb to
900kb(almost 1 mb). Will it affect the performance. I am using mediumblob
for this.
2.Secondly, if I am storing for eg.
this is my_table
id pic
varchar(50) mediumblob
suppose if i insert 3 rows like
insert into my_table('aaaa', load_file('c:/images/a.jpeg')) ;
insert into my_table('bbbb', load_file('c:/images/b.bmp')) ;
insert into my_table('cccc', load_file('c:/images/c.gif')) ;
is there any way of knowing the
1. file type eg. jpeg, bmp, gif
2. name of the file inserted. eg. a,b,c
3. Thirdly
does mysql treat jpeg and jpg formats differently?
4.Is there any reason to fear, the blob data get corrupted while inserting
or selecting ?
for eg. if I issue a statement like this from the command prompt
select * from my_table ;
thanks for any suggestions ?
---------------------------------------------------------------------
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
