MySQL Forums
Forum List  »  MySQL Workbench

Code Help
Posted by: Jeremy Bushnell
Date: August 05, 2015 11:30AM

I have got several errors on due to Syntax error: missing 'closing parethesis.' I am assuming it has something to do with either the foreign or primary keys. and help would be great.These are the error that I am getting.
1. Under "Employee" table 2nd to last line at "PRIMARY KEY" I keep getting the Syntax error: missing 'closing parethesis.
2. Under "Customer" table at "PRIMARY KEY" I keep getting the Syntax error: missing 'closing parethesis.Below that on the "Index" line I am getting two errors the first one is on the "Index" itself Syntax error: missing 'closing parethesis. Then on the same line I get Syntax error: unexpected 'EMP_ID' (back tick quoted id).
3. Under the Vendor table again on the "Primary Key" line i get Syntax error: missing 'closing parethesis.
4. Under "Acounts" table on the first "Index" line I get Syntax error: missing 'closing parethesis.
5. Under "Accounts" right below the first "Index" line on the second "Index" line I have two errors. First one is Syntax error: missing 'closing parethesis.
second error on that same line is Syntax error: unexpected 'V_ID' (back tick quoted id).
6. Then again with both Index issues for "Delivery" tabel.
I am new to database so any help would be greatly appreciated. Below is my code,
Thanks in advance!





-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema JeremyBushnell_Database
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema JeremyBushnell_Database
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `JeremyBushnell_Database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `JeremyBushnell_Database` ;

-- -----------------------------------------------------
-- Table `JeremyBushnell_Database`.`Employee`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `JeremyBushnell_Database`.`Employee` ;

CREATE TABLE IF NOT EXISTS `JeremyBushnell_Database`.`Employee` (
`EMP_ID` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'EMPLOYEE ID NUMBER',
`EMP_FNAME` VARCHAR(35) NOT NULL COMMENT 'EMPLOYEE FIRST NAME',
`EMP_LNAME` VARCHAR(35) NOT NULL COMMENT 'EMPLOYEE LAST NAME',
`EMP_PHONE` CHAR(12) NOT NULL COMMENT 'EMPLOYEE PHONE NUMBER',
`EMP_ADD` VARCHAR(100) NOT NULL COMMENT 'EMPLOYEE ADDRESS',
`EMP_TITLE` VARCHAR(50) NOT NULL COMMENT 'EMPLOYEE TITLE',
`EMP_SALMTD` DECIMAL(10,2) ZEROFILL NOT NULL COMMENT 'EMPLOYEE SALES/SALARY MONTH TO DATE',
`EMP_SALYTD` DECIMAL(10,2) ZEROFILL NOT NULL COMMENT 'EMPLOYEE SALES/SALARY YEAR TO DATE',
`EMP_COMMTD` DECIMAL(10,2) ZEROFILL NOT NULL COMMENT 'EMPLOYEE COMMISSIONS MONTH TO DATE',
`EMP_COMYTD` DECIMAL(10,2) ZEROFILL NOT NULL COMMENT 'EMPLOYEE COMMISSIONS YEAR TO DATE',
PRIMARY KEY (`EMP_ID`) COMMENT '')
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `JeremyBushnell_Database`.`Customer`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `JeremyBushnell_Database`.`Customer` ;

CREATE TABLE IF NOT EXISTS `JeremyBushnell_Database`.`Customer` (
`CUST_ID` INT(10) NOT NULL COMMENT 'CUSTOMER ID NUMBER',
`CUST_FNAME` VARCHAR(35) NOT NULL COMMENT 'CUSTOMER FIRST NAME',
`CUST_LNAME` VARCHAR(45) NOT NULL COMMENT 'CUSTOMER LAST NAME',
`CUST_PHONE` CHAR(12) NOT NULL COMMENT 'CUSTOMER PHONE NUMBER',
`CUST_ADD` VARCHAR(100) NOT NULL COMMENT 'CUSTOMER ADDRESS',
`CUST_ZIP` CHAR(5) NOT NULL COMMENT 'CUSTOMER ZIP CODE',
`CUST_INVOICE` INT(10) NOT NULL COMMENT 'CUSTOMER INVOIVE NUMBER',
`EMP_ID` INT(10) NOT NULL COMMENT 'EMPLOYEE ID NUMBER',
PRIMARY KEY (`CUST_ID`) COMMENT '',
INDEX `EMP_ID_idx` (`EMP_ID` ASC) COMMENT '',
CONSTRAINT `EMP_ID`
FOREIGN KEY (`EMP_ID`)
REFERENCES `JeremyBushnell_Database`.`Employee` (`EMP_ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `JeremyBushnell_Database`.`Vendor`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `JeremyBushnell_Database`.`Vendor` ;

CREATE TABLE IF NOT EXISTS `JeremyBushnell_Database`.`Vendor` (
`V_ID` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'VENDOR ID NUMBER',
`V_NAME` VARCHAR(35) NOT NULL COMMENT 'VENDOR NAME',
`V_ADD` VARCHAR(100) NOT NULL COMMENT 'VENDOR ADDRESS',
`V_INVOICE` INT(10) NOT NULL COMMENT 'VENDOR INVOICE NUMBER',
PRIMARY KEY (`V_ID`) COMMENT '')
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `JeremyBushnell_Database`.`Accounts`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `JeremyBushnell_Database`.`Accounts` ;

CREATE TABLE IF NOT EXISTS `JeremyBushnell_Database`.`Accounts` (
`EMP_ID` INT(10) NOT NULL COMMENT '',
`V_ID` INT(10) NOT NULL COMMENT '',
`ACC_MEMO` MEDIUMTEXT NULL COMMENT '',
INDEX `EMP_ID_idx` (`EMP_ID` ASC) COMMENT '',
INDEX `V_ID_idx` (`V_ID` ASC) COMMENT '',
CONSTRAINT `EMP_ID_ACC`
FOREIGN KEY (`EMP_ID`)
REFERENCES `JeremyBushnell_Database`.`Employee` (`EMP_ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `V_ID_ACC`
FOREIGN KEY (`V_ID`)
REFERENCES `JeremyBushnell_Database`.`Vendor` (`V_ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `JeremyBushnell_Database`.`Delivery`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `JeremyBushnell_Database`.`Delivery` ;

CREATE TABLE IF NOT EXISTS `JeremyBushnell_Database`.`Delivery` (
`CUST_ID` INT(10) NOT NULL COMMENT 'CUSTOMER ID NUMBER',
`V_ID` INT(10) NOT NULL COMMENT 'VENDOR ID NUMBER',
`DELIV_NOTES` VARCHAR(45) NULL COMMENT 'DELIVERY NOTES',
INDEX `CUST_ID_idx` (`CUST_ID` ASC) COMMENT '',
INDEX `V_ID_idx` (`V_ID` ASC) COMMENT '',
CONSTRAINT `CUST_ID`
FOREIGN KEY (`CUST_ID`)
REFERENCES `JeremyBushnell_Database`.`Customer` (`CUST_ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `V_ID`
FOREIGN KEY (`V_ID`)
REFERENCES `JeremyBushnell_Database`.`Vendor` (`V_ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

Options: ReplyQuote


Subject
Views
Written By
Posted
Code Help
1906
August 05, 2015 11:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.