[sqlite] drop, create and copy a table

2015-11-27 Thread Héctor Fiandor
ers-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] En nombre de H?ctor Fiandor Enviado el: jueves, 26 de noviembre de 2015 07:22 a. m. Para: 'SQLite mailing list' Asunto: Re: [sqlite] drop, create and copy a table Dear Mr. Smith and Dr. Hipp: Tha

[sqlite] drop, create and copy a table

2015-11-26 Thread R Smith
On 2015/11/26 4:08 AM, H?ctor Fiandor wrote: > Dear Mr. Hipp and other members: > > I have a table where I have introduced a lot of information during 2015. > > In December 31, I have to select the records to be continue in 2016. > Previously, I have obtained a copy of the 2015 table for any cons

[sqlite] drop, create and copy a table

2015-11-26 Thread Héctor Fiandor
inal- De: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] En nombre de R Smith Enviado el: jueves, 26 de noviembre de 2015 02:46 a. m. Para: sqlite-users at mailinglists.sqlite.org Asunto: Re: [sqlite] drop, create and copy a table On 2015/1

[sqlite] drop, create and copy a table

2015-11-25 Thread Héctor Fiandor
p. m. Para: 'General Discussion of SQLite Database' Asunto: [sqlite] drop, create and copy a table Dear members: I have asked previously about this matter but nobody answer me. I have a table to be copied in another one with other name as a temp. Then I drop the first one. Then I create a

[sqlite] drop, create and copy a table

2015-11-25 Thread Bernardo Sulzbach
What are you trying to do? Rename the table? You can use https://www.sqlite.org/lang_altertable.html for that. Please make your intentions clearer. On Wed, Nov 25, 2015 at 6:43 PM, H?ctor Fiandor wrote: > Dear members: > > > > I have asked previously about this matter but nobody answer me. > >

[sqlite] drop, create and copy a table

2015-11-25 Thread Igor Tandetnik
On 11/25/2015 3:43 PM, H?ctor Fiandor wrote: > I have asked previously about this matter but nobody answer me. > > I have a table to be copied in another one with other name as a temp. > > Then I drop the first one. > > Then I create another one with same as the dropped table. > > Then I copy from

[sqlite] drop, create and copy a table

2015-11-25 Thread Richard Hipp
On 11/25/15, H?ctor Fiandor wrote: > Dear members: > > > > I have asked previously about this matter but nobody answer me. > > I have a table to be copied in another one with other name as a temp. > > Then I drop the first one. > > Then I create another one with same as the dropped table. > > Then

[sqlite] drop, create and copy a table

2015-11-25 Thread Héctor Fiandor
Dear members: I have asked previously about this matter but nobody answer me. I have a table to be copied in another one with other name as a temp. Then I drop the first one. Then I create another one with same as the dropped table. Then I copy from the temp to the new created. I do all t