I'm having trouble inserting a row into my geopolygon table. For some reason MySQL wont let me insert a row with a "PolyGroup" value. All columns, which are not primary keys, allow NULL values and the primary key is set on "AUTO_INCREMENT", thus allowing to insert a row with only "PolyGroup" given. To the best of my knowledge the synthax seems to be correct (it's only inserting an int value, how hard can it be?). So what's the problem?
Heres the tabledefinition in MySQL (generated by HeidiSQL):
CREATE TABLE `geopolygone` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`PolyGroup` INT(11) NULL DEFAULT NULL,
`Geo` POLYGON NULL DEFAULT NULL,
`Projekt` INT(11) NULL DEFAULT NULL,
`Name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`Begin` DATETIME NULL DEFAULT NULL,
`End` DATETIME NULL DEFAULT NULL,
`Rep` VARCHAR(50) NULL DEFAULT NULL COMMENT 'gives options to repeat timesections daily, weekly, yearly' COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`ID`) USING BTREE,
INDEX `PolyProjekt` (`Projekt`) USING BTREE,
CONSTRAINT `PolyProjekt` FOREIGN KEY (`Projekt`) REFERENCES `jm 3.0 (version 0.1)`.`projekte` (`projektID`) ON UPDATE NO ACTION ON DELETE NO ACTION)
COLLATE='utf8mb4_general_ci' ENGINE=InnoDB ;
and this is the insert statement:
INSERT INTO geopolygone ('PolyGroup') VALUES (12);
the error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''PolyGroup')VALUES (12)' at line 1 */
thank you for any suggestions!
