Insert Statement Problem

[daniyalnawaz]

Hi guys!

Whats wrong with this statement

INSERT INTO MarketData(symbol,date,time,trade_price,change)VALUES('A','2007-09-27',16:00:00,36.12,'0.00')

im getting a following error
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'change)VALUES('A','2007-09-27','16:00:00',36.12,'0.00')' at line 1


My table structure is:

CREATE TABLE `MarketData` (
  `MarketData_ID` int(10) unsigned NOT NULL auto_increment,
  `symbol` varchar(6) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `time` time default NULL,
  `trade_price` decimal(8,2) default NULL,
  `change` varchar(10) default NULL,
  PRIMARY KEY  (`MarketData_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[mwasif]

Change is a reserve word in MySQL and you need to use backtick around that column name. And use quotes around time value.

INSERT INTO MarketData(symbol,date,time,trade_price,`change`) VALUES('A','2007-09-27','16:00:00',36.12,'0.00')

[mwasif]

Moved to MySQL Forum.

[daniyalnawaz]

Thank You!!! Its working now.... :)

[mwasif]

You are welcome, post back whenever you need help.