On 7 Mar 2015, at 4:42pm, Dave <theschemer at cox.net> wrote: > I am fairly new at this although I have wanted to learn and tried again and > again...But I have a problem. I created a database and probably did it wrong > and I am trying to fix it. I made a database with 7 tables in it all with a > primary key and a record ID that matches the primary key. Now when trying to > use the database I see that I should have made 1 table with all the related > data (I think) and am trying to copy one column of data at a time to the > "main" table. Can that be done and if so how?
Without going into your situation in detail, I have a suggestion which may help you approach the problem another way. The SQLite shell tool has a '.dump' command which turns a database into SQL commands, and a '.read' command which uses the commands to create schema and data in a new database. So dump the database into a text file. Then you can use editing tools (usually global find-and-replace) mess with the text file so that all the inserting is done to the same table. Then you can create your new database by reading the altered text file. Simon.
