Simon, Yes, thank you. ALL, After recreating the table this way I had to restart sqlite console as otherwise all queries to the table were dead.
Is this normal? Thank you. On Mon, Dec 3, 2012 at 1:42 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 3 Dec 2012, at 1:08am, Igor Korot <ikoro...@gmail.com> wrote: > >> I thought that simply using ".backup/.restore" will give me what I want, >> but it gives me a file in internal format. >> What I am trying to do is do make a text file which gives me all SQL command >> that was issued (CREATE TABLE and INSERT) than fix the particular CREATE >> TABLEu. > > Ah. You're using the wrong commands. You want .dump/.read. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
