Page 1 of 1

SQL Syntax Error on MySQL database

Posted: Tue Dec 02, 2008 3:57 pm
by nathaliamota
I have the following table in a mysql database:

CREATE TABLE IF NOT EXISTS `CASE` (
`CASE_NUM` bigint(20) unsigned NOT NULL auto_increment,
`DATE` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`PERSON_ID` int(11) NOT NULL,
`RESIDENCY_DETAILS_ID` int(11) NOT NULL,
`MORT_COMP_ID` int(11) NOT NULL,
`LOAN_ID` int(11) NOT NULL,
`INTAKE_REPRE_ID` int(11) default NULL,
`COUNSELOR_ID` int(11) default NULL,
PRIMARY KEY (`CASE_NUM`),
UNIQUE KEY `PERSON_ID` (`PERSON_ID`),
UNIQUE KEY `RESIDENCY_DETAILS_ID` (`RESIDENCY_DETAILS_ID`),
UNIQUE KEY `LOAN_ID` (`LOAN_ID`),
KEY `INTAKE_REPRE_ID` (`INTAKE_REPRE_ID`),
KEY `COUNSELOR_ID` (`COUNSELOR_ID`),
KEY `MORT_COMP_ID` (`MORT_COMP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

And I am trying to insert data to it. I have tried all of the following pieces of SQL code:

insert into CASE (PERSON_ID, RESIDENCY_DETAILS_ID, MORT_COMP_ID, LOAN_ID, INTAKE_REPRE_ID, COUNSELOR_ID) values (1, 2, 3, 4, 5, 6);

insert into CASE (PERSON_ID, RESIDENCY_DETAILS_ID, MORT_COMP_ID, LOAN_ID) values (1, 2, 3, 4);

insert into CASE (DATE, PERSON_ID, RESIDENCY_DETAILS_ID, MORT_COMP_ID, LOAN_ID, INTAKE_REPRE_ID, COUNSELOR_ID) values ("2003-12-31 01:02:03", 1, 2, 3, 4, 5, 6);

None of them work! They all generate a syntax error. Can anyone help me figure out what is wrong with it?

Thank you

Re: SQL Syntax Error on MySQL database

Posted: Tue Dec 02, 2008 11:33 pm
by Peter Anselmo
It wasn't immediately obvious, so I plugged your statements into a terminal. I found ticks (`) were needed around CASE for it to work.

Try this:

Code: Select all

insert into `CASE` (PERSON_ID, RESIDENCY_DETAILS_ID, MORT_COMP_ID, LOAN_ID, INTAKE_REPRE_ID, COUNSELOR_ID) values (1, 2, 3, 4, 5, 6);