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 '');