Re: DBI: error in SQL syntax.

[VSarkiss]

You have the right answer above: there's no TABLE keyword in an INSERT statement.

I just wanted to add a hint that may save you some grief later on: rather than depending on the implicit order of columns in your INSERT, list them explicitly:

INSERT INTO
    pocus ( chr, start, stop, gene_name, score, strand )
VALUES
    ( ?, ?, ?, ?, ?, ? )

This way, even if the table definition changes, your statement will do what you intend.