· 8 years ago · Apr 24, 2018, 04:10 AM
1CREATE TABLE IF NOT EXISTS `test`.`t1` (
2 `col` VARCHAR(16) NOT NULL
3) ENGINE=MEMORY;
4
5SET sql_notes = 0; -- Temporarily disable the "Table already exists" warning
6CREATE TABLE IF NOT EXISTS ...
7SET sql_notes = 1; -- And then re-enable the warning again
8
9sudo mysqladmin flush-tables
10
11mysqladmin: refresh failed; error: 'Access denied; you need the RELOAD privilege for this operation'