linux清空数据库命令

DROP DATABASE database_name;
CREATE DATABASE database_name;

USE database_name;
SET FOREIGN_KEY_CHECKS = 0;
-- 获取所有表名
SELECT CONCAT('DROP TABLE IF EXISTS `', table_name, '`;') 
FROM information_schema.tables 
WHERE table_schema = 'database_name';
SET FOREIGN_KEY_CHECKS = 1;

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP
        EXECUTE 'DROP TABLE IF EXISTS "' || quote_ident(r.tablename) || '" CASCADE';
    END LOOP;
END $$;

mongo
use database_name
db.dropDatabase()

sqlite3 database_name.db
.tables
DROP TABLE table_name;

#!/bin/bash

# 数据库连接信息
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database"

# 清空数据库
mysql -u $DB_USER -p$DB_PASS -e "DROP DATABASE $DB_NAME; CREATE DATABASE $DB_NAME;"