importing data to a table that has generated-columns
chiahui chen <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CADOxComedADu3x-EjvR5xSPKw-Q9mazswTCnVdsYhdZFAc1Ypg@mail.gmail.com> |
Hi, After creating a table (total 8 columns including 1 generated column) , I tried to import data from a csv file (each record has values for 7 columns that match the non-generated column names and data types, no headers ). The system issued " error: table has 7 columns but 8 values were supplied. ' I wonder why. After experimenting different ways to import data to a table that has a generated column, so far I only found that .read command with a .sql file that was output as a result of 'mode insert' is successful. Is there any other ways to import data to an existing generated-column table? Thank you advance. Chiahui _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users