Export and view LKDatabase under 65.iOS

One. Export

Xcode- > window- > devices and Simulators

Select your own project in Name

Then click on the icon that is a bit like the setting, and select Download Container...

two。 Check the database 2.1.cd to the file export directory, enter the exported folder-> cd AppData/Documents/LKHTest, and then you can see the db file of LK, as follows:

2.2 Open the db file

Enter sqlite3 lkdbhelperTest.db on the command line

Of course, you can also open it with the database view tool.

three。 Basic sqlite3 syntax .exit.help View help displays database information for the command .database; contains the location of the current database. Tables or .table shows the table name does not display if there is no table, the .schema command can view the SQL command when the data object is created; select * from tbl_xxx