i use a exporter for some mysql data. At first it will create the table and after that insert the data into it.
Example Code
DROP TABLE IF EXISTS `dbc_Item-data`;
CREATE TABLE `dbc_Item-data` (
`id` INT NOT NULL DEFAULT '0',
`field97` INT NOT NULL DEFAULT '0',
`field98` INT NOT NULL DEFAULT '0',
`field99` INT NOT NULL DEFAULT '0',
`field100` INT NOT NULL DEFAULT '0',
`field101` INT NOT NULL DEFAULT '0',
)
The Result was a Mysql Syntax Error, - after some research i found that the ,
before the last line will stop him from importing. So because my exporter is done via c++ i can't change currently this (also i can't write c), so my question is: Is there any workarround in the serverconf for this? I rather would like not to change every .sql file via an editor.
Sincerly Yours from Germany Jonathan