The Ultimate Guide to High Availability with MariaDB

Comments - SET Variable statement

8 years, 7 months ago Elena Stepanova
Re: SET Variable statement [Answer]

You need prepared statements to pull it off. Something like

SET @dbname = 'name';
SET @sql = CONCAT('drop database if exists ', @dbname);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.