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
SQL Syntax Error on MySQL database
Moderator: General Moderators
-
nathaliamota
- Forum Newbie
- Posts: 1
- Joined: Wed Sep 10, 2008 6:39 pm
- Peter Anselmo
- Forum Commoner
- Posts: 58
- Joined: Wed Feb 27, 2008 7:22 pm
Re: SQL Syntax Error on MySQL database
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:
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);