Advanced Search

alle Tabellen eines bestimmten Musters aus einer Datenbank löschen

/ Published in: MySQL
Save to your folder(s)
drop_tables_like(pattern, db)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. use osamos2;
  2. delimiter $$
  3. create procedure drop_tables_like(pattern varchar(255), db varchar(255))
  4. begin
  5. select @str_sql:=concat('drop table ', group_concat(table_name))
  6. from information_schema.tables
  7. where table_schema=db and table_name like pattern;
  8.  
  9. prepare stmt from @str_sql;
  10. execute stmt;
  11. drop prepare stmt;
  12. end$$
  13.  
  14. call drop_tables_like('ALT_%', 'osamos2')$$
  15.  
  16. drop procedure if exists drop_tables_like$$
  17. delimiter ;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.