error #1064 ved UPDATE
HiCREATE TABLE `frontpage` (
`frontId` char(2) NOT NULL default '',
`left` text,
`right` text,
PRIMARY KEY (`frontId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Forespørgsel:
UPDATE frontpage SET left='test', right='test' WHERE frontId='f'
Jeg får denne fejl når jeg forsøger en UPDATE via phpMyAdmin:
#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 'left='test', right='test' WHERE frontId='f'' at line 1
Ved updates i andre tabeller i samme db får jeg ikke fejlen, fx.
CREATE TABLE `tekst` (
`btId` char(1) character set latin1 NOT NULL default '',
`header` text character set latin1,
`tekst` text character set latin1 NOT NULL,
PRIMARY KEY (`btId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
