RE: [sqlite] Importing data without a primary key

2007-02-28 Thread Griggs, Donald
-Original Message- From: Sebastian Tennant [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 12:56 PM To: sqlite-users@sqlite.org Subject: [sqlite] Importing data without a primary key Hi all, I have a CSV file of data that doesn't include a column suitable to be the primary

[sqlite] Importing data without a primary key

2007-02-28 Thread Sebastian Tennant
Hi all, I have a CSV file of data that doesn't include a column suitable to be the primary key. Should I edit the CSV data file before importing it (a pain to do), or is there an easy way to create (and populate) a primary key column once the data has been imported? Any suggestions much