Once the database is created, we may want to see if the data in the database was successfully inserted, and many people prefer to use the graphical interface tools to manage the SQLite database. SQLite GUI management tool has many, I recommend using Sqlitestudio tool, Http://sqlitestudio.pl/?act=download. The Sqlitestudio tool supports cross-platform support for multiple languages, including Chinese. You can export a variety of formats such as SQL, CSV, HTML, and XML.
Start the Sqlitestudio tool, interface, through the menu "database" → "add Database", Pop-up dialog box, in the database file select "< project directory >\proj.win32\debug.win32\ Noteslist.sqlite3", Noteslist.sqlite3 is generated by initializing the database.
Using the Sqlitestudio tool
Add Database Dialog Click the "OK" button to open the database, in the left navigation tree, double-click "Noteslist.sqlite3" → "Table" → "Note", and then click on the right "data" tab, so we can open the Note table. The shortcut button below us manages the table.
Open Note table
Manage table shortcut buttons
In addition, we can manage the database through the Sqlitestudio tool. Sqlitestudio tools are very powerful and we don't introduce them.
For more information, please pay attention to the first Cocos2d-x 3.2 Edition book "Cocos2d-x: C + + volume" book Exchange Discussion website: http://www.cOcoagame.net
For more exciting video courses, please follow Cocos class: http://v.51wOrk6.com
Welcome to join Cocos2d-x Technical Discussion group: 257760386Welcome to Luxgen iOS Classroom public platform
SQLite database management tool in Cocos2d-x