I do believe that would be the ticket! Thanks much :) Regards, Ben http://defiledroid.wordpress.com/
On Apr 6, 7:03 pm, theSmith <[email protected]> wrote: > I believe this is what you want. > > DROP TABLE character2 > > SELECT * > INTO character2 > FROM character3 > > --------------- > Creator of My College Lifehttp://mycollegelife.org > > On Apr 6, 9:50 pm, Jason LeBlanc <[email protected]> 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 <[email protected]> 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 [email protected] > > > To unsubscribe from this group, send email to > > > [email protected]<android-developers%2Bunsubs > > > [email protected]> > > > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
