oracle
SELECT 'DROP TABLE '|| table_name || ';' FROM USER_TABLES;
mysql
SELECT CONCAT('DROP TABLE ',TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES WHERE table_schema IN ('数据库');
mysql和oracle 拼接删除 语句
最新推荐文章于 2024-07-20 16:33:27 发布