|
608
by Brian Aker
Adding snowman test (plus a dead variable removal). |
1 |
CREATE DATABASE ☃;
|
2 |
DROP DATABASE ☃;
|
|
3 |
CREATE DATABASE `☃`;
|
|
4 |
DROP DATABASE `☃`;
|
|
5 |
USE test;
|
|
6 |
CREATE TABLE ☃ (a INT NOT NULL);
|
|
7 |
INSERT INTO ☃ VALUES(1);
|
|
8 |
INSERT INTO ☃ VALUES(2);
|
|
9 |
SELECT a FROM ☃;
|
|
10 |
a
|
|
11 |
1
|
|
12 |
2
|
|
13 |
DELETE FROM ☃ WHERE a = 1;
|
|
14 |
UPDATE ☃ SET a = 3 WHERE a = 2;
|
|
15 |
TRUNCATE ☃;
|
|
16 |
RENAME TABLE ☃ TO t1;
|
|
17 |
CREATE DATABASE ☃;
|
|
18 |
DROP DATABASE ☃;
|
|
19 |
CREATE DATABASE `☃`;
|
|
20 |
DROP DATABASE `☃`;
|
|
|
1119.4.6
by Stewart Smith
make snowman test not leave tables behind after running |
21 |
DROP TABLE t1;
|