Programming Forums - another mysql prob

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Other Scripting Languages (http://www.programmingforums.org/forum39.html)

- - another mysql prob (http://www.programmingforums.org/showthread.php?t=13328)

teishu

Jun 11th, 2007 4:07 PM

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

dr.p	Jun 11th, 2007 4:41 PM

Well, VARCHAR[10] differs from the normal definition of VARCHAR(10). Aside from that, I don't see anything. It would help if you would post the error message(s) that you are getting.

teishu

Jun 11th, 2007 5:22 PM

thats it, cheers m8, didn't see that wrong type of bracket :(

All times are GMT -5. The time now is 10:43 AM.