csv file is generated by a program. Program generatin csv do not know the existing id values from database table.
Program can keep id blank or '' or null or some suitable value in csv file, which SQLite import should understand to generate next id automatically by SQLite itself to use it as primary key. But then for first column what to write in csv file ? Any of the following do not work. /* sample records from csv file data.csv */ ,'name_text_1' '','name_text_3' null,'name_text_2' 'null','name_text_4' Thanks for helping. Rohit -- View this message in context: http://www.nabble.com/import-operation---primary-key-need-to-be-automatically-generated-by-SQLite-%28not-from-csv-file%29-tf3360094.html#a9359741 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
