{"id":11356,"date":"2024-03-14T13:54:18","date_gmt":"2024-03-14T13:54:18","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/"},"modified":"2025-08-04T10:49:16","modified_gmt":"2025-08-04T10:49:16","slug":"how-to-empty-all-tables-in-a-database-using-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/","title":{"rendered":"How to Truncate All MySQL Tables"},"content":{"rendered":"

To empty all tables in the database, you can use the following command:<\/p>\n

    \n
  1. Firstly, connect to the database.<\/li>\n<\/ol>\n
    mysql -u \u7528\u6237\u540d -p \u6570\u636e\u5e93\u540d\r\n<\/code><\/pre>\n
      \n
    1. Then use the following command to truncate all tables:<\/li>\n<\/ol>\n
      SET FOREIGN_KEY_CHECKS = 0;\r\nSET GROUP_CONCAT_MAX_LEN=32768;\r\nSET @tables = NULL;\r\nSELECT GROUP_CONCAT(table_name) INTO @tables\r\n  FROM information_schema.tables\r\n  WHERE table_schema = DATABASE();\r\nSELECT IFNULL(@tables,'dummy') INTO @tables;\r\n\r\nSET @tables = CONCAT('TRUNCATE TABLE ', @tables);\r\nPREPARE stmt FROM @tables;\r\nEXECUTE stmt;\r\nDEALLOCATE PREPARE stmt;\r\n\r\nSET FOREIGN_KEY_CHECKS = 1;\r\n<\/code><\/pre>\n
      This will clear all tables in the database. Please note that this will delete all data in the tables, but will not delete the table structures. If you need to delete the table structures, you can use the DROP TABLE command.<\/p>\n","protected":false},"excerpt":{"rendered":"
      To empty all tables in the database, you can use the following command: Firstly, connect to the database. mysql -u \u7528\u6237\u540d -p \u6570\u636e\u5e93\u540d Then use the following command to truncate all tables: SET FOREIGN_KEY_CHECKS = 0; SET GROUP_CONCAT_MAX_LEN=32768; SET @tables = NULL; SELECT GROUP_CONCAT(table_name) INTO @tables FROM information_schema.tables WHERE table_schema = DATABASE(); SELECT IFNULL(@tables,’dummy’) INTO […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[284,513,298,1012,14633],"class_list":["post-11356","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database","tag-database-management","tag-mysql","tag-sql-commands","tag-truncate-tables"],"yoast_head":"\nHow to Truncate All MySQL Tables - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to quickly empty all MySQL database tables with a simple script. Step-by-step guide to truncate all tables efficiently.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Truncate All MySQL Tables\" \/>\n<meta property=\"og:description\" content=\"Learn how to quickly empty all MySQL database tables with a simple script. Step-by-step guide to truncate all tables efficiently.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T13:54:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T10:49:16+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How to Truncate All MySQL Tables\",\"datePublished\":\"2024-03-14T13:54:18+00:00\",\"dateModified\":\"2025-08-04T10:49:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\"},\"wordCount\":74,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database\",\"Database Management\",\"MySQL\",\"SQL commands\",\"truncate tables\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\",\"name\":\"How to Truncate All MySQL Tables - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T13:54:18+00:00\",\"dateModified\":\"2025-08-04T10:49:16+00:00\",\"description\":\"Learn how to quickly empty all MySQL database tables with a simple script. Step-by-step guide to truncate all tables efficiently.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Truncate All MySQL Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Truncate All MySQL Tables - Blog - Silicon Cloud","description":"Learn how to quickly empty all MySQL database tables with a simple script. Step-by-step guide to truncate all tables efficiently.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to Truncate All MySQL Tables","og_description":"Learn how to quickly empty all MySQL database tables with a simple script. Step-by-step guide to truncate all tables efficiently.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T13:54:18+00:00","article_modified_time":"2025-08-04T10:49:16+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How to Truncate All MySQL Tables","datePublished":"2024-03-14T13:54:18+00:00","dateModified":"2025-08-04T10:49:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/"},"wordCount":74,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database","Database Management","MySQL","SQL commands","truncate tables"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/","name":"How to Truncate All MySQL Tables - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T13:54:18+00:00","dateModified":"2025-08-04T10:49:16+00:00","description":"Learn how to quickly empty all MySQL database tables with a simple script. Step-by-step guide to truncate all tables efficiently.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-empty-all-tables-in-a-database-using-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Truncate All MySQL Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=11356"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11356\/revisions"}],"predecessor-version":[{"id":155130,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11356\/revisions\/155130"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=11356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=11356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=11356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}