· 7 years ago · Feb 19, 2019, 08:26 PM
1$ cat test.sql
2SET @DB_DATABASE_NAME = "test_db";
3SET @DB_TABLE_NUMBERS = "name_number";
4
5DROP DATABASE IF EXISTS @DB_DATABASE_NAME;
6CREATE DATABASE IF NOT EXISTS @DB_DATABASE_NAME;
7
8USE @DB_DATABASE_NAME;
9
10CREATE TABLE IF NOT EXISTS @DB_TABLE_NUMBERS
11(
12 `nn_id` INT PRIMARY KEY AUTO_INCREMENT,
13 `nn_name` VARCHAR(64) CHARACTER SET utf8,
14 `nn_number` VARCHAR(18) CHARACTER SET utf8
15);
16
17$ mysql -v -uroot -pMMGhbfb8sFYYbJCh < test.sql
18--------------
19SET @DB_DATABASE_NAME = "test_db"
20--------------
21
22--------------
23SET @DB_TABLE_NUMBERS = "name_number"
24--------------
25
26--------------
27DROP DATABASE IF EXISTS @DB_DATABASE_NAME
28--------------
29
30ERROR 1064 (42000) at line 4: You have an error in your SQL syntax; check the ma
31nual that corresponds to your MariaDB server version for the right syntax to us
32e near '@DB_DATABASE_NAME' at line 1