First MySQL Query.

[Ruud Hermans]

OK, just wrote my first MySQL Query to set up some tables in a database. Could some on look over it if possible.

 

The parts I am worried about most are these (image will hold a thumbnail).

 

date DATE()

eatable ENUM ('yes', 'no', 'partly', 'poison')

comments TEXT()

image BLOB()

 

CREATE TABLE address (id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, password VARCHAR(30) NOT NULL, email VARCHAR(30), location VARCHAR(30) NOT NULL, date DATE());

CREATE TABLE address (id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(200), latinname VARCHAR(200), date DATE(), location VARCHAR(255), eatable ENUM ('yes', 'no', 'partly', 'poison'), comments TEXT(), image BLOB());

[trq]

Its generally considered a better option to let your filesystem store images. Simply store the path to the file within your database.

[Ruud Hermans]

Its generally considered a better option to let your filesystem store images. Simply store the path to the file within your database.

How would I exactly do that if the file is on a server reffer to the URL or to the path?

 

What would it lool like in the query then, image VARCHAR(100)?

[fenway]

You'd store a relative pathname to the image itself.