Steve Grosz [EMAIL PROTECTED] wrote:
I'm just getting into the whole MySql (was using access). Is it better
to create a Blob type and insert a image into it, or to create a char
file type and have a directory structure to the specific file?
It's FAQ. One of the most FA Q.
Store image in
Generally, it is not advised to add pictures to tables. See
http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images
We had this question here some days ago, so it may ge a good idea
to discuss at length possible problems why people won't like this
approach of storing pics as files.
WARNING:
Thanks, regarding the PHP info.
What I need to know is:
1. what would the create table statment look like in Mysql.
2. Should I use a longblob based on my 100k .gif size?
3. Is one column with the gifs enough. Or should I add a autoincremented
primary key?
4. Is it better to have a
What I need to know is:
1. what would the create table statment look like in Mysql.
DROP TABLE IF EXISTS pictures;
CREATE TABLE pictures (
id mediumint(4) NOT NULL auto_increment,
comment text NOT NULL,
width smallint(6) DEFAULT '0' NOT NULL,
height smallint(6) DEFAULT '0' NOT
I'm using mysql in win9x, and I want to know how to load a JPG image into a table
__
Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/
Hello avegaaraya,
Thursday, May 31, 2001, 6:12:09 PM, you wrote:
ann I'm using mysql in win9x, and I want to know how to load a JPG image into a table
ann __
ann Get your own FREE, personal Netscape Webmail account today at