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: 467

Filed under:
|
|

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

Related posts about mysql

Related posts about syntax