Breaking News: Grepper is joining You.com. Read the official announcement!

mysql drop all tables

bakkar answered on August 30, 2022 Popularity 10/10 Helpfulness 4/10

answer mysql drop all tables

related delete all from mysql table

mysql drop all tables

Comment

# Make sure you are inside the target database, if not add "USE you_database;"
DROP PROCEDURE IF EXISTS `drop_all_tables`;

DELIMITER $$
CREATE PROCEDURE `drop_all_tables`()
BEGIN
    DECLARE _done INT DEFAULT FALSE;
    DECLARE _tableName VARCHAR(255);
    DECLARE _cursor CURSOR FOR
        SELECT table_name 
        FROM information_schema.TABLES
        WHERE table_schema = SCHEMA();
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET _done = TRUE;

    SET FOREIGN_KEY_CHECKS = 0;

    OPEN _cursor;

    REPEAT FETCH _cursor INTO _tableName;

    IF NOT _done THEN
        SET @stmt_sql = CONCAT('DROP TABLE ', _tableName);
        PREPARE stmt1 FROM @stmt_sql;
        EXECUTE stmt1;
        DEALLOCATE PREPARE stmt1;
    END IF;

    UNTIL _done END REPEAT;

    CLOSE _cursor;
    SET FOREIGN_KEY_CHECKS = 1;
END$$

DELIMITER ;

call drop_all_tables(); 

DROP PROCEDURE IF EXISTS `drop_all_tables`;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 20 2023

bakkar

0 Answers Avg Quality 2/10

Closely Related Answers

delete all from mysql table

Comment

-1

DELETE FROM table_name
WHERE condition;
Code language: SQL (Structured Query Language) (sql)

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.mysqltutorial.org

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Aug 30 2022

Cameron MacKay

0 Answers Avg Quality 2/10

mysql drop all tables

Contents

More Related Answers

mysql drop all tables

Closely Related Answers

delete all from mysql table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.