1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
# Test Snowman Unicode character for creation
# of tables and databases.
# Test without backticks
CREATE DATABASE ☃;
DROP DATABASE ☃;
# Now with backticks
CREATE DATABASE `☃`;
DROP DATABASE `☃`;
# Now try table names
USE test;
# Test table creation without backticks
# And various operations on the table
CREATE TABLE ☃ (a INT NOT NULL);
INSERT INTO ☃ VALUES(1);
INSERT INTO ☃ VALUES(2);
SELECT a FROM ☃;
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;
|