I believe this is what you want. DROP TABLE character2
SELECT * INTO character2 FROM character3 --------------- Creator of My College Life http://mycollegelife.org On Apr 6, 9:50 pm, Jason LeBlanc <jasonalebl...@gmail.com> wrote: > Try these search terms. Not sure if they are supported by SQLite though as I > don't know much about it. > > COPY TABLE > > SELECT INTO > > J > > On Tue, Apr 6, 2010 at 8:25 PM, Ben <defiledr...@gmail.com> wrote: > > Hi all, > > > As always I searched high and low to no avail. I don't doubt the > > answer is out there, but it evaded me. > > > In my game I am handling the loss of a character (represented > > programmatically with their own table) - however there are 4 such > > tables. I would like to know if there is a simple way to simply tell > > SQLite to make character 2's entire table equal character 3's? Just > > trying to not leave a gap in the lineup. > > > I was considering pulling all the data, sorting it out, putting it > > into the table and then deleting - I just wanted to know if there was > > a nifty shortcut to tell SQLite that I wanted to duplicate an entire > > table at another preexisting table? > > > Any help would be greatly appreciated. > > > Ben > >http://defiledroid.wordpress.com/ > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to android-developers@googlegroups.com > > To unsubscribe from this group, send email to > > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com> > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en > > > To unsubscribe, reply using "remove me" as the subject. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en