View Single Post
Old Jun 11th, 2007, 4:07 PM   #1
teishu
Programmer
 
Join Date: May 2006
Posts: 49
Rep Power: 0 teishu is on a distinguished road
another mysql prob

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
__________________
Intel Pentium M 1.73Ghz -- Sony Vaio -- 1024MB Ram -- Ubuntu 8.04
AMD Athlon X2 4200+ -- Asus V3-M2V890 -- 2GB Kingston -- Vista Ultimate 32bit
Intel C2D E4400 -- 2048MB GeIL - Windows XP SP2

ASCII stupid question, get a stupid ANSI !
teishu is offline   Reply With Quote