CREATE TABLE joke ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, joketext TEXT, jokedate DATE NOT NULL ); INSERT INTO joke SET joketext = "Why did the chicken cross the road? To get to the other side!", jokedate = "2007-01-21"; //or INSERT INTO joke (joketext, jokedate) VALUES ( "Why did the chicken cross the road? To get to the other side!", "2007-01-21" );