From: Alex Gutteridge <alexg@...>
Date: 2007-08-02T09:07:51+09:00
Subject: Re: parse xml file, put results in mysql db

On 1 Aug 2007, at 19:01, Hans Meier wrote:

> Ok, thank you. I found the failure, but get a new failure:
>
> DBI::DatabaseError: 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 ')
>                    VALUES ('735i','Alcatel','1133')' at line 1

The error message tells you what to do. Check the syntax of your SQL.  
You have:

>> "INSERT INTO mobil_devices (model, manufacturer,mobil_device_id,)  
>> VALUES (?,?,?)"

Can you see the error? It is just where the error message tells you  
it is. You have an extra ',' in your column list.

Alex Gutteridge

Bioinformatics Center
Kyoto University