Snippet for HeidiSQL (and other DB managers)

Recreate selected database.sql

-- BE ATTENTIVE BEFORE USE!

SELECT DATABASE() INTO @db;

DO
	@qdrop := CONCAT("DROP DATABASE `", @db, "`"),
	@qcreate := CONCAT("CREATE DATABASE `", @db, "` /*!40100 COLLATE 'utf8mb4_general_ci' */");

PREPARE stmt FROM @qdrop;
EXECUTE stmt;

PREPARE stmt FROM @qcreate;
EXECUTE stmt;

USE @db;