Hello, community! I want to create a new table, its primary key is an int 'id' column, but I don't want to insert the data by hand, I hope the system can generate it by adding id.
For example, mytable(id, name, age) When I insert name and age, the id is generated automatically. And another question about this: How can I import data from a file, and SPECIFY the column? For example, how to insert the follow file into mytable which I define as before: age name 18 Frank 16 Niu Talk 16 Jim Note: the table is defined as (id, age, name),but the file is wrote as (age name). How can I do it? I'm newbie for sqlite, so this may be a easy question, and I hope somebody can help me:P Thanks. Have Fun! Kermit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
