Dave I'm not sure exactly what you are trying to do from your description - the schema of the tables you have and those that you want may help.
But as a general idea you might be able to use something along the lines of create table newtable as select x, y, z from oldtable More info here: https://www.sqlite.org/lang_createtable.html Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 7 March 2015 at 19:08, Dave <theschemer at cox.net> wrote: > Thanks Simon. If I can't figure that out I will just type all the data in > manually and learn from the school of hard knocks. :-) I googles it and it > seems that I am not the only one that has tried to do this and it seems like > it should be easy. I think in regular SQL it might be easier. Oh well, I had > my app data "hard coded" in the past and decided to use a database to make > it easier. I am sure it will be, once I get more experience. > schemer > > > On 3/7/2015 11:59 AM, Simon Slavin wrote: >> >> 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. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
