Sqlite3---terminal operation

Go to Sandbox path

Create a Stu.sql database

Sqlite3 Stu.sql

Create a table

CREATE table if not exists Student (ID integer primary key autoincrement,name varchar[20] not null,address Varchar[100],im Age blob);

To view your own creation statement

Inserting data

Insert into Student (name,address) VALUES ("Huoran", "Ruanjianyuan");

Find

SELECT * from Student where id = 2;

Select name from Student where id = 2;

Update

Update Student Set address = "Nanjing" WHERE name = "Baoyun";

Delete

Delete from Student where id = 1;

Delete a table

drop table Student;

Add:

SQLite> SELECT * from company LIMIT 3 OFFSET 2;

Start at least a few lines from which line

Sqlite3---terminal operation