Re: Can anyone help me

[Kelly Penhall-Wilson]

That's correct - I suppose I wasn't clear, you have to put *something* in the placeholder such as an empty string '', or NULL, putting nothing without either of those two will produce an error.

CREATE TABLE `tab3` (
`pkey` int(11) NOT NULL auto_increment,
`col1` varchar(50) default NULL,
`col2` varchar(50) default NULL,
PRIMARY KEY (`pkey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into tab3 values(,'somevalue','someothervalue')

produces this error:

Error Code : 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 ''somevalue','someothervalue')' at line 1
(0 ms taken)

while this
insert into tab3 values('','somevalue','someothervalue')

works-