2022-03-sqlite3的命令行使用 #

sqlite3 qianqu

.table

.header on
.mode column
.timer on

select * from custom_nav;

DROP TABLE database_name.table_name;

INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]  
VALUES (value1, value2, value3,...valueN);

DELETE FROM table_name WHERE [condition];

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

ALTER TABLE database_name.table_name ADD COLUMN column_def...;

ALTER TABLE database_name.table_name RENAME TO new_table_name;