Fejl i mysql sætning
Er der nogen der kan fortælle mig hvad der er galt med følgende sql sætning?INSERT INTO js_experience (userid, fromyear1, toyear1, businessline1, company1, position1, moreinfo1, fromyear2, toyear2, businessline2, company2, position2, moreinfo2, fromyear3, toyear3, businessline3, company3, position3, moreinfo3, fromyear4, toyear4, businessline4, company4, position4, moreinfo4, fromyear5, toyear5, businessline5, company5, position5, moreinfo5) VALUES (59, 2000, 2001, '1', 'Jul A/S 1', 'Ceh1', 'Mere info1', 2001, 2002, '1', 'Jul 2', 'Chef 2', 'Det var sjovt2', 2002, 2003, '1', 'Jul3', 'Chef3', 'Info3', , , '', '', '', '', , , '', '', '', '')
Fejlmeddelelsen er:
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 ' , '', '', '', '', , , '', '', '', '')' at line 1
Kan man ikke indsætte tomme felter?
Min tabel er som følger:
CREATE TABLE `js_experience` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`userid` mediumint(8) unsigned NOT NULL default '0',
`fromyear1` smallint(5) unsigned NOT NULL default '0',
`toyear1` smallint(5) unsigned NOT NULL default '0',
`businessline1` varchar(255) collate latin1_danish_ci NOT NULL default '',
`company1` varchar(255) collate latin1_danish_ci NOT NULL default '',
`position1` varchar(255) collate latin1_danish_ci NOT NULL default '',
`moreinfo1` text collate latin1_danish_ci NOT NULL,
`fromyear2` smallint(5) unsigned NOT NULL default '0',
`toyear2` smallint(5) unsigned NOT NULL default '0',
`businessline2` varchar(255) collate latin1_danish_ci NOT NULL default '',
`company2` varchar(255) collate latin1_danish_ci NOT NULL default '',
`position2` varchar(255) collate latin1_danish_ci NOT NULL default '',
`moreinfo2` text collate latin1_danish_ci NOT NULL,
`fromyear3` smallint(5) unsigned NOT NULL default '0',
`toyear3` smallint(5) unsigned NOT NULL default '0',
`businessline3` varchar(255) collate latin1_danish_ci NOT NULL default '',
`company3` varchar(255) collate latin1_danish_ci NOT NULL default '',
`position3` varchar(255) collate latin1_danish_ci NOT NULL default '',
`moreinfo3` text collate latin1_danish_ci NOT NULL,
`fromyear4` smallint(5) unsigned NOT NULL default '0',
`toyear4` smallint(5) unsigned NOT NULL default '0',
`businessline4` varchar(255) collate latin1_danish_ci NOT NULL default '',
`company4` varchar(255) collate latin1_danish_ci NOT NULL default '',
`position4` varchar(255) collate latin1_danish_ci NOT NULL default '',
`moreinfo4` text collate latin1_danish_ci NOT NULL,
`fromyear5` smallint(5) unsigned NOT NULL default '0',
`toyear5` smallint(5) unsigned NOT NULL default '0',
`businessline5` varchar(255) collate latin1_danish_ci NOT NULL default '',
`company5` varchar(255) collate latin1_danish_ci NOT NULL default '',
`position5` varchar(255) collate latin1_danish_ci NOT NULL default '',
`moreinfo5` text collate latin1_danish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=25 ;
