> ---- Mensaje original ---- > De: Csányi Pál <csanyi...@gmail.com> > Para: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Fecha: Mon, 28 Aug 2017 15:50:13 +0200 > Asunto: Re: [sqlite] Converting an sqlite database into format that > anAndroid app can uses? >
>I understand. >If I open the Probe.db to edit in Midnight Comander, then I find there >one line only, which begin like: >SQLite format 3^@^P^@^A^A^@@ ^@^@^@^B^@^@^@^C^@^@^@^ .. etc... > >So it is definitely a database file and not a text file. > >For newbies like me it should be mentioned this at >https://www.sqlite.org/quickstart.html >bellow the 'Create A New Database' title, >and below the line: >Enter SQL commands at the prompt to create and populate the new database. > >like: > >When one finished entering SQL commands and used the ".quit" command >to exit the shell tool, then there will be not a text, but a database >file which can then be used on various devices, like smart phones, >etc. > >No? It seem obvious even to newbies as your that after created the very first database, the next step would be try some commands against the new file to see how it behaves. I.E. .tables, .schema, .dbinfo, .dump, .show or whatever. If the response is some Ok. then the thing is a database and well formed. H.T.H. -- Adolfo J. Millan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
