· 7 years ago · Feb 17, 2019, 05:30 PM
1##### Part of bash script #####
2
3mysql -u"${MARIADB_USER}" -p"${MARIADB_PASS}" -e "
4 CREATE DATABASE IF NOT EXISTS ${MY_DB};
5"
6
7# Whitelist table
8mysql -u"${MARIADB_USER}" -p"${MARIADB_PASS}" -e "
9 USE ${MY_DB};
10 CREATE TABLE IF NOT EXISTS ${MY_WHITE_TABLE}
11 ('key' INT NOT NULL AUTO_INCREMENT, 'number' VARCHAR(16) CHARACTER SET utf8);
12"
13
14##### Error message without details #####
15
16ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''key' INT NOT NULL AUTO_INCREMENT, 'number' VARCHAR(16) CHARACTER SET utf8)' at line 2