[R] RMySQL unique primary key ??

Benton, Paul hpaul.benton08 at imperial.ac.uk
Mon Nov 30 20:18:16 CET 2009


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




More information about the R-help mailing list