从 Linux shell 与 .db 文件交互

与Linux Shell与.db文件交互的自然语言生成文章

bash
   sudo apt-get install sqlite3
   

bash
   sqlite3 your_database.db
   

sql
   CREATE TABLE students (
       id INTEGER PRIMARY KEY,
       name TEXT,
       age INTEGER
   );
   

sql
   INSERT INTO students (name, age) VALUES ('John Doe', 25);
   

sql
   SELECT * FROM students;
   

bash
#!/bin/bash
# 连接到数据库
sqlite3 students.db <
# 创建表
CREATE TABLE IF NOT EXISTS students (
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER
);
# 插入数据
INSERT INTO students (name, age) VALUES ('Alice', 22);
INSERT INTO students (name, age) VALUES ('Bob', 24);
# 查询数据
SELECT * FROM students;
EOF