error in mysql syntax
        Posted  
        
            by fusion
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by fusion
        
        
        
        Published on 2010-04-09T17:31:07Z
        Indexed on 
            2010/04/09
            17:33 UTC
        
        
        Read the original article
        Hit count: 528
        
while executing the following query, i get an error that there's an error in the syntax near line 9. since i'm using mysql workbench, i can't really figure out what could be wrong:
CREATE  TABLE IF NOT EXISTS `proquotes`.`thquotes` (
  `idQuotes` INT NOT NULL AUTO_INCREMENT ,
  `vAuthorID` VARCHAR(8) CHARACTER SET 'utf8' NOT NULL ,
  `vAuthor` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL ,
  `cQuotes` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL ,
  `cArabic` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL ,
  `vReference` VARCHAR(100) CHARACTER SET 'utf8' NOT NULL ,
  PRIMARY KEY (`idQuotes`) ,
  INDEX `vAuthorID` () ,
  CONSTRAINT `vAuthorID`
    FOREIGN KEY ()
    REFERENCES `proquotes`.`author_info` ()
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
DEFAULT CHARACTER SET = utf8;
© Stack Overflow or respective owner