SQLite3 用法总结

创建数据库：sqlite3 db_name.db

创建表：CREATE TABLE table_name (column_name data_type, ...);

插入数据：INSERT INTO table_name (column_name, ...) VALUES (value, ...);

查询数据：SELECT column_name FROM table_name WHERE condition;

更新数据：UPDATE table_name SET column_name = value WHERE condition;

删除数据：DELETE FROM table_name WHERE condition;