Syntax Error #1064

bthomasowns · 06-27-2009, 04:51 PM

Im using Mysql 4.1

Step: Just add this sql

insert into control
values('CONFIG_MAX_START_DB','3','Maximum allowed starting DBs',null,'0','0')

When i add values('CONFIG_MAX_START_DB','3','Maximum allowed starting DBs',null,'0','0')

I get a syntax error #1064

Any help please?

vikaskaforum · 06-30-2009, 02:04 PM

okie ... r u using phpadmin

HivelocityDD · 06-30-2009, 06:14 PM

Are you trying to run this from any application or from command line. If you are using either one try NULL instead of null and also make sure to put ; in the end of the SQL statement

Also most importantly make sure the fields types match the values being entered

06-30-2009, 02:04 PM	#2
vikaskaforum New Hunter Join Date: Jun 2009 Posts: 90 HB$ Balance: 0 iTrader: (0)	okie ... r u using phpadmin __________________ database books \| JAVA BOOKS\| Online pdf Books \| Free Online Books

06-30-2009, 06:14 PM	#3
HivelocityDD Field Master Join Date: Jan 2009 Location: localhost Posts: 561 HB$ Balance: 0 iTrader: (0)	Are you trying to run this from any application or from command line. If you are using either one try NULL instead of null and also make sure to put ; in the end of the SQL statement Also most importantly make sure the fields types match the values being entered __________________ Dedicated Servers - sales@hivelocity.net - 1-888-869-HOST(4678)

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

06-27-2009, 04:51 PM	#1
bthomasowns New Hunter Join Date: Jun 2009 Posts: 2 HB$ Balance: 0 iTrader: (0)	Syntax Error #1064 Im using Mysql 4.1 Step: Just add this sql insert into control values('CONFIG_MAX_START_DB','3','Maximum allowed starting DBs',null,'0','0') When i add values('CONFIG_MAX_START_DB','3','Maximum allowed starting DBs',null,'0','0') I get a syntax error #1064 Any help please?