Commonly used sQlite statements and the use and registration of sQlite developer, sqlitedeveloper

Commonly used sQlite statements and the use and registration of sQlite developer, sqlitedeveloper

Preface

SQlite is a lightweight database commonly used in development. Generally, it only occupies several hundred KB of memory space. Therefore, in ios development, Apple uses sQlite as a database application in Apple development. Of course, fmdb is another matter. Here, we mainly want to differentiate sQlite statements, mySql statements, and Oracle statements.

Summary of commonly used sQlite statements

1. create table

create table student( id integer primary key autoincrement, name varchar(20) not null, cid integer, age integer check(age >18 and age<60), gender bit default 1, score real);

Note:Here, the differences between autoincrement, check, bit, and real are as follows.

2. insert

 insert into student (name,cid,age,gender,score) values ('tom',1,20,1,20);

3. update statement

update student set name='jack' where name='tom';

Note the following:In SQL statements, do not use single quotation marks for any data type except strings and date and time!

4. query statement select

select * from student where id=1;

Note the following:* In the select statement represents a field.

5. delete statement delete from

delete from student where score<60;

To delete a table, you must specify the where condition. Otherwise, the data table is cleared directly.

How to Use and register Sqlite Developer

Sqlite databases are the most used for Android development, but database files of the db type are not easy to view. This software can be used at this time.

This is the home page of the program, and the list of databases is displayed on the left.

Right-click the Database List and you can choose to register a database and create a database. To register a database, copy the db file in your mobile phone and add it to the database.

Create a database

After the database is imported, a gray database file will appear below. Double-click to highlight and expand, open the table, right-click to query data ===>

In the input box above, you can enter the statement for adding, deleting, modifying, and querying. after entering the statement, you can select the line or lines with the mouse and click the magnifier in the upper left corner to run the statement.

This software has a registration. After the trial, it will require registration before it can continue to be used.

Solution

Start-> Run-> cmd, or the window + R key combination to bring up the command window

Copy: reg delete "HKEY_CURRENT_USER \ SharpPlus \ SqliteDev"/v "StartDate"/f to the window and press Enter.

Summary

The above is all the content of this article. I hope the content of this article has some reference and learning value for everyone's learning or work. If you have any questions, please leave a message to us, thank you for your support.