Programming Forums > Script Programming > Other Scripting Languages

teishu · Jun 11th, 2007, 4:07 PM

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

Jun 11th, 2007, 4:07 PM	#1
teishu Programmer Join Date: May 2006 Posts: 49 Rep Power: 0	another mysql prob Hi, can someone tell me what is wrong with the syntax of this: (Toggle Plain Text) 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; 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 !*

Jun 11th, 2007, 4:41 PM	#2
dr.p Programmer Join Date: Feb 2006 Location: Ohio Posts: 93 Rep Power: 3	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. __________________ Neeley.org

Jun 11th, 2007, 5:22 PM	#3
teishu Programmer Join Date: May 2006 Posts: 49 Rep Power: 0	thats it, cheers m8, didn't see that wrong type of bracket __________________ 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 !*

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Connecting MySQL and PHP	titaniumdecoy	PHP	10	Feb 25th, 2008 7:47 PM
MySQL & Python	snipertomcat	Python	2	May 9th, 2007 12:49 PM
MySQl simple problem	paulchwd	Other Web Development Languages	7	Feb 27th, 2007 10:31 AM
MySql	paulchwd	Other Web Development Languages	8	Feb 8th, 2007 9:17 PM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 9:28 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Script Programming > Other Scripting Languages

another mysql prob