DBI: Insert into composite key columns

[diyaz]

Maybe this is a very simple error, but I can't seem to insert into a primary composite key of two columns: Chr and Pos.

$dbh->do(qq(INSERT INTO Position(Chr,Pos) VALUES(?,?)),
                         undef,
                         $chr,
                         $pos);

I keep getting a mySQL syntax error, but this exact syntax works in all my other id columns so the only difference I can is this one is a composite key. When I insert row in HeidiSQL it works with the same syntax it seems.

Message: DBD::mysql::db do failed: 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 'Position(Chr,Pos) VALUES('X','123456')' at line 1

[poj]

Position (Chr,Pos)

Add space after Position. Position is not a good name for a table as POSITION() is a function in MySQL

poj

[diyaz]

!!!! oh man thank you! it works! Did not realize that.