或者在shell提示符下,只需两行代码,不需要命名临时文件,假设$db是SQLite数据库名称: echo "SELECT 'DROP TABLE ' || name ||';' FROM sqlite_master WHERE type = 'table';" | sqlite3 -readonly "$db" | sqlite3 "$db"