-- 
CREATE TABLE `artist` (
`ArtistID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`Artist` varchar( 40 ) NOT NULL default '',
PRIMARY KEY ( `ArtistID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COMMENT = 'List of Ornament Artists' AUTO_INCREMENT =55;

MySQL said: Documentation
#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 'DEFAULT CHARSET=latin1 COMMENT='List of Ornament Artists' AUTO_