1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
CREATE DATABASE ☃; DROP DATABASE ☃; CREATE DATABASE `☃`; DROP DATABASE `☃`; USE test; CREATE TABLE ☃ (a INT NOT NULL); INSERT INTO ☃ VALUES(1); INSERT INTO ☃ VALUES(2); SELECT a FROM ☃; a 1 2 DELETE FROM ☃ WHERE a = 1; UPDATE ☃ SET a = 3 WHERE a = 2; TRUNCATE ☃; RENAME TABLE ☃ TO t1; CREATE DATABASE ☃; DROP DATABASE ☃; CREATE DATABASE `☃`; DROP DATABASE `☃`; DROP TABLE t1; |