{"absolute_url": "/jbmckee/drop-multiple-tables-wildcard/", "blog_post": false, "code": "mysql -u root -D db_name -e \"show tables\" -s | \n  egrep \"^wp_2_\" | \n  xargs -I \"@@\" echo mysql -u root -D db_name -e \"DROP TABLE @@\"", "created": "2019-06-24T14:30:53.392737", "description": "", "description_rendered": "", "embed_url": "https://snipt.net/embed/e5a728f8eb841e563749391bd636044e/", "full_absolute_url": "/jbmckee/drop-multiple-tables-wildcard/", "id": 72, "lexer": "text", "line_count": 3, "log_entries": [{"code": "mysql -u root -D db_name -e \"show tables\" -s | \n  egrep \"^wp_2_\" | \n  xargs -I \"@@\" echo mysql -u root -D db_name -e \"DROP TABLE @@\"", "created": "2019-06-24T14:30:53.495144", "diff": "--- \n+++ \n@@ -0,0 +1,3 @@\n+mysql -u root -D db_name -e \"show tables\" -s | \n+  egrep \"^wp_2_\" | \n+  xargs -I \"@@\" echo mysql -u root -D db_name -e \"DROP TABLE @@\"", "user": "jbmckee"}], "meta": "", "modified": "2026-04-25T16:09:50.674989", "publish_date": "2019-06-24T14:30:53.356008", "raw_url": "/raw/e5a728f8eb841e563749391bd636044e/", "resource_uri": "/api/public/snipt/72/", "slug": "drop-multiple-tables-wildcard", "stylized": "<table class=\"highlighttable\"><tr><td class=\"linenos\"><div class=\"linenodiv\"><pre><a href=\"#L-1\">1</a>\n<a href=\"#L-2\">2</a>\n<a href=\"#L-3\">3</a></pre></div></td><td class=\"code\"><div class=\"highlight\"><pre><span></span><span id=\"L-1\"><a name=\"L-1\"></a>mysql -u root -D db_name -e &quot;show tables&quot; -s | \n</span><span id=\"L-2\"><a name=\"L-2\"></a>  egrep &quot;^wp_2_&quot; | \n</span><span id=\"L-3\"><a name=\"L-3\"></a>  xargs -I &quot;@@&quot; echo mysql -u root -D db_name -e &quot;DROP TABLE @@&quot;\n</span></pre></div>\n</td></tr></table>", "tags": [], "title": "Drop multiple tables wildcard", "user": {"absolute_url": "/jbmckee/", "email_md5": "f4da96308b6db1b0b19738a7c105d3da", "id": 1, "resource_uri": "/api/public/user/1/", "snipts": "/api/public/snipt/?user=1", "snipts_count": 72, "username": "jbmckee"}}