CREATE TABLE `MDB_appointments` (
`A_ID` int(11) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`time` varchar(20) NOT NULL default '',
`type` varchar(24) NOT NULL default '',
`notes` text NOT NULL,
PRIMARY KEY (`A_ID`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
==> gives me this error :
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 '"MDB_appointments" (`A_ID` int(11) NOT NULL auto_increment,`date` date NOT NULL ' at line 1
why ?