[thelist] MySQL CREATE TABLE - img file??

[kristina]

Dear all,

  I hope I was clear enough with the subject....

  What is the syntax to include an img?  I am trying to create a
  little database which can have an img included with the entry.

  so far I have:

CREATE TABLE courses (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  timestamp DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
  course TEXT NOT NULL,
  startdate DATE NOT NULL,
  enddate DATE NOT NULL,
  location TEXT NOT NULL,
  tutor TEXT,
  description TEXT,
  photo  ???????
);

--
tia
~kristina

kristina at kfx-design.co.uk
http://kfx-design.co.uk/