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 consult. In 2016, the year start with a table "cleaned" of the old records, with the records to be continued as the firsts, for these reasons, I thought to drop the table and create a new one, "cleaned" of any history related to 2015, with the Id starting in "1". Really, I don?t know that making the step (2) suggested by Mr. Hipp followed by step (3) without dropping the table "clean" the history of the table and start the Id with "1". Really, I have not used de BEGIN...COMMINT commands. I will test the routines as suggested by Mr. Hipp. Any suggestion will be received as a gift. Thanks very much for your answers. Yours Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu -----Mensaje original----- De: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] En nombre de H?ctor Fiandor Enviado el: mi?rcoles, 25 de noviembre de 2015 03:43 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 another one with same as the dropped table. Then I copy from the temp to the new created. I do all this but in three phases I may answer is It is possible to do this in one phase? Thanks in advance Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
