Hi guys!
Whats wrong with this statement
[CODE=mysql]INSERT INTO MarketData(symb ol,date,time,tr ade_price,chang e)VALUES('A','2 007-09-27',16:00:00,36 .12,'0.00')[/CODE]
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:
[CODE=mysql]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 ;[/CODE]
Whats wrong with this statement
[CODE=mysql]INSERT INTO MarketData(symb ol,date,time,tr ade_price,chang e)VALUES('A','2 007-09-27',16:00:00,36 .12,'0.00')[/CODE]
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:
[CODE=mysql]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 ;[/CODE]
Comment