TEXT 10
SQL execution By admin on 5th November 2021 11:45:57 PM
  1. Executing SQL script in server
  2. ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
  3.   CONSTRAINT `creatorid`
  4.     FOREIGN KEY (`creatorid`)
  5.     REFERENCES `azzie...' at line 9
  6. SQL Code:
  7.         -- -----------------------------------------------------
  8.         -- Table `azziedev_attendtudb`.`sessions`
  9.         -- -----------------------------------------------------
  10.         CREATE TABLE IF NOT EXISTS `azziedev_attendtudb`.`sessions` (
  11.           `idsessions` INT NOT NULL,
  12.           `creatorid` VARCHAR(20) NOT NULL,
  13.           `courseid` INT NULL,
  14.           PRIMARY KEY (`idsessions`),
  15.           INDEX `netid_idx` (`creatorid` ASC) INVISIBLE,
  16.           CONSTRAINT `creatorid`
  17.             FOREIGN KEY (`creatorid`)
  18.             REFERENCES `azziedev_attendtudb`.`users` (`netid`)
  19.             ON DELETE NO ACTION
  20.             ON UPDATE NO ACTION)
  21.         ENGINE = InnoDB
  22.  
  23. SQL script execution finished: statements: 8 succeeded, 1 failed
  24.  
  25. Fetching back view definitions in final form.
  26. Nothing to fetch

Paste is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.