Hello

I'm very new to MySQL & PHP Programming. I'm trying to Develop a Script by Following a Tutorial.

Tutorial Says to Use these SQL Queries, But I fails.

PHP Code:

CREATE TABLE `short_urls` (
`id` int(11) NOT NULL auto_increment,
`short` varchar(6) NOT NULL,
`url` varchar(1000) NOT NULL,
`stamped` datetime NOT NULL,
PRIMARY KEY  (`id`),
KEY `short` (`short`)
) ENGINE=MyISAM  DEFAULT; 


It says

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8

Can anyone Help me to fix this problem.

Thank you,

Try:

CREATE TABLE `short_urls` (
`id` int(11) NOT NULL auto_increment,
`short` varchar(6) NOT NULL,
`url` varchar(1000) NOT NULL,
`stamped` datetime NOT NULL,
PRIMARY KEY  (`id`),
KEY `short` (`short`)
) ENGINE=MyISAM

Thanks.. It worked