Hi, can someone tell me what is wrong with the syntax of this:
CREATE TABLE `bank`.`template` (
`Date` VARCHAR[10] NOT NULL,
`Type` VARCHAR(3) NOT NULL,
`Description` VARCHAR(90) NOT NULL,
`Value` DOUBLE NOT NULL,
`Balance` DOUBLE NOT NULL,
`Account Name` VARCHAR(90) NOT NULL,
`Account Number` VARCHAR(45) NOT NULL
)
ENGINE = InnoDB;
It doesn't seem to like it...
thanks