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 ?