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
|
# Test Clef Unicode character for creation
# of tables and databases. This is interesting as it's > 2**16
# 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;
|