MySQL User-Defined Variable Values Can't be Used as Identifiers. How do I do this?

Question

According to the manual:

User variables... cannot be used directly in an SQL statement as an identifier or as part of an identifier, such as in contexts where a table or database name is expected

Which explains why what I've been trying doesn't work:

set @databaseName := 'job_hunt_2';

drop database @databaseName;
create database @databaseName;
use @databaseName;

Is there a way to accomplish this, or is it simply impossible? Thanks!

heximal · Accepted Answer · 2010-11-18 08:07:59Z

3

may be you should try following approach:

set @databaseName := 'job_hunt_2';
SET @s = CONCAT('drop database ', @databaseName); 
PREPARE stmt1 FROM @s; 
EXECUTE stmt1; 
DEALLOCATE PREPARE stmt1;

answered Nov 18, 2010 at 8:07

heximal

10.5k5 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL User-Defined Variable Values Can't be Used as Identifiers. How do I do this?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related