Skip to content

RMySQL unique primary key ??

1 message · Benton, Paul

#
Dear R-guru's,

I have some data that I'm writing to a mysql database. I need the database to generate the primary key and it's not being generated as a unique ID. My understanding was that primary keys should be unique. I submit a data.frame with named columns. The only name that it's missing is the primary key. Currently I have two entries with 0 as their primary key ?!?!?!?!

Any ideas??

Thanks,

Paul

H. Paul Benton
Graduate Student
Biomolecular Medicine
Imperial College London
South Kensington
hpaul.benton08 at imperial.ac.uk