MySQL Forums
Forum List  »  MySQL Workbench

Error 1064 - MySQL Workbench 6.3 Community
Posted by: Adnan Dossaji
Date: July 07, 2015 08:32AM

Hi all I am getting an Error 1064 on a statement. Not sure why I am getting it since I am using Workbench. I am using Server version: 5.6.24 MySQL Community Server (GPL). I have noticed that other people have the same issue, if this Workbench is generating the code, why are there syntax errors? Is there a permanent fix for this?

Here is my code

CREATE TABLE `app_cubs`.`ticket-status` (
  `category_id`  NULL COMMENT '',
  `event_date` DATETIME NULL COMMENT '',
  `event_name` VARCHAR(45) NULL COMMENT '',
  `request_num` INT NULL COMMENT '',
  `status` VARCHAR(45) NULL COMMENT '',
  `purpose` VARCHAR(45) NULL COMMENT '',
  `comp_ticket_request` VARCHAR(45) NULL COMMENT '',
  `paid_ticket_request` VARCHAR(45) NULL COMMENT '',
  `comp_ticket_approved` VARCHAR(45) NULL COMMENT '',
  `paid_ticket_approved` VARCHAR(45) NULL COMMENT '',
  `comp_ticket_fulfilled` VARCHAR(45) NULL COMMENT '',
  `paid_ticket_fulfilled` VARCHAR(45) NULL COMMENT '',
  PRIMARY KEY (`category_id`)  COMMENT '');

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 1064 - MySQL Workbench 6.3 Community
2756
July 07, 2015 08:32AM


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.