Generally speaking, the free version is enough to meet our needs. SQLite expert is a simple and compact SQLite database management software, there are free version and paid version.

You can use the graphical interface to analyze and modify etc. Moreover, the SQLite database itself is an independent file, which is easy to grab from the simulator. Therefore, it is best to write the SQL statement in a graphical environment first, and then test it before adding it to the code. Select * from user order by _id // Sort by id select * from user order by _id desc // Sort in reverse order of idįew people write SQL statements directly in the program, which is troublesome and error-prone. Desc // View table structure select * from // Query all changes select, from table // View the specified column select distinct, from table // Unique query insert into users(_id,username,password) select * from users // copy select username from users where username like ' S% ' // Non-renamed users with a capital S select username from users where username like ' _S% ' // Users whose third letter of the non-renamed name is capital S select * from users where _id in ( 001, 220, 230 )

Sqlite expert professional