sqlite3数据库和表的相关命令
1、创建一个新的数据库:
sqlite3
CREATE TABLE Cars(Id integer PRIMARY KEY,Name text,Cost integer); INSERT INTO Cars VALUES(1,'Audi',52642); INSERT INTO Cars VALUES(2,'Mercedes',57127); INSERT INTO Cars VALUES(3,'Skoda',9000); INSERT INTO Cars VALUES(4,'Volvo',29000); INSERT INTO Cars VALUES(5,'Bentley',350000); INSERT INTO Cars VALUES(6,'Citroen',21000); INSERT INTO Cars VALUES(7,'Hummer',41400); INSERT INTO Cars VALUES(8,'Volkswagen',21600); COMMIT; BEGIN TRANSACTION; CREATE TABLE Orders(Id integer PRIMARY KEY,OrderPrice integer CHECK(OrderPrice>0), INSERT INTO Orders(OrderPrice,Customer) VALUES(1200,'Williamson'); INSERT INTO Orders(OrderPrice,Customer) VALUES(200,'Robertson'); INSERT INTO Orders(OrderPrice,Customer) VALUES(40,Customer) VALUES(1640,'Smith'); INSERT INTO Orders(OrderPrice,Customer) VALUES(100,Customer) VALUES(50,Customer) VALUES(150,Customer) VALUES(250,Customer) VALUES(840,'Brown'); INSERT INTO Orders(OrderPrice,Customer) VALUES(440,'Black'); INSERT INTO Orders(OrderPrice,Customer) VALUES(20,'Brown'); COMMIT; BEGIN TRANSACTION; CREATE TABLE Friends(Id integer PRIMARY KEY,Name text UNIQUE NOT NULL, INSERT INTO Friends VALUES(1,'Jane','F'); INSERT INTO Friends VALUES(2,'Thomas','M'); INSERT INTO Friends VALUES(3,'Franklin','M'); INSERT INTO Friends VALUES(4,'Elisabeth','F'); INSERT INTO Friends VALUES(5,'Mary','F'); INSERT INTO Friends VALUES(6,'Lucy','F'); INSERT INTO Friends VALUES(7,'Jack','M'); COMMIT; BEGIN TRANSACTION; CREATE TABLE INSERT INTO Customers(Name) VALUES('Paul Novak'); INSERT INTO Customers(Name) VALUES('Terry Neils'); INSERT INTO Customers(Name) VALUES('Jack Fonda'); INSERT INTO Customers(Name) VALUES('Tom Willis'); CREATE TABLE INSERT INTO Reservations(CustomerId,Day) VALUES(1,'2009-22-11'); INSERT INTO Reservations(CustomerId,Day) VALUES(2,'2009-28-11'); INSERT INTO Reservations(CustomerId,'2009-29-11'); INSERT INTO Reservations(CustomerId,Day) VALUES(3,'2009-02-12'); COMMIT; BEGIN TRANSACTION; CREATE TABLE Names(Id integer,Name text); INSERT INTO Names VALUES(1,'Tom'); INSERT INTO Names VALUES(2,'Lucy'); INSERT INTO Names VALUES(3,'Frank'); INSERT INTO Names VALUES(4,'Jane'); INSERT INTO Names VALUES(5,'Robert'); COMMIT; BEGIN TRANSACTION; CREATE TABLE Books(Id integer PRIMARY KEY,Title text,Author text, INSERT INTO Books VALUES(1,'War and Peace','Leo Tolstoy','978-0345472403'); INSERT INTO Books VALUES(2,'The Brothers Karamazov', INSERT INTO Books VALUES(3,'Crime and Punishment','978-1840224306'); COMMIT; 4、列出所有的数据表: .tables 完成上面所有的工作以后,我们就可以列出所有的数据表了
7、导出某个表的数据:.dump (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |