|
1
by brian
clean slate |
1 |
drop database if exists `mysqltest1`; |
2 |
drop database if exists `mysqltest-1`; |
|
3 |
drop database if exists `#mysql50#mysqltest-1`; |
|
4 |
create database `mysqltest1`; |
|
5 |
create database `#mysql50#mysqltest-1`; |
|
6 |
create table `mysqltest1`.`t1` (a int); |
|
7 |
create table `mysqltest1`.`#mysql50#t-1` (a int); |
|
8 |
create table `#mysql50#mysqltest-1`.`t1` (a int); |
|
9 |
create table `#mysql50#mysqltest-1`.`#mysql50#t-1` (a int); |
|
10 |
show create database `mysqltest1`; |
|
11 |
Database Create Database |
|
12 |
mysqltest1 CREATE DATABASE `mysqltest1` /*!40100 DEFAULT CHARACTER SET latin1 */ |
|
13 |
show create database `mysqltest-1`; |
|
14 |
ERROR 42000: Unknown database 'mysqltest-1' |
|
15 |
show create database `#mysql50#mysqltest-1`; |
|
16 |
Database Create Database |
|
17 |
#mysql50#mysqltest-1 CREATE DATABASE `#mysql50#mysqltest-1` /*!40100 DEFAULT CHARACTER SET latin1 */
|
|
18 |
show tables in `mysqltest1`; |
|
19 |
Tables_in_mysqltest1
|
|
20 |
#mysql50#t-1
|
|
21 |
t1
|
|
22 |
show tables in `#mysql50#mysqltest-1`; |
|
23 |
Tables_in_#mysql50#mysqltest-1 |
|
24 |
#mysql50#t-1
|
|
25 |
t1
|
|
26 |
show create database `mysqltest1`; |
|
27 |
Database Create Database |
|
28 |
mysqltest1 CREATE DATABASE `mysqltest1` /*!40100 DEFAULT CHARACTER SET latin1 */ |
|
29 |
show create database `mysqltest-1`; |
|
30 |
Database Create Database |
|
31 |
mysqltest-1 CREATE DATABASE `mysqltest-1` /*!40100 DEFAULT CHARACTER SET latin1 */ |
|
32 |
show create database `#mysql50#mysqltest-1`; |
|
33 |
ERROR 42000: Unknown database '#mysql50#mysqltest-1' |
|
34 |
show tables in `mysqltest1`; |
|
35 |
Tables_in_mysqltest1
|
|
36 |
t1
|
|
37 |
t-1 |
|
38 |
show tables in `mysqltest-1`; |
|
39 |
Tables_in_mysqltest-1 |
|
40 |
t1
|
|
41 |
t-1 |
|
42 |
drop database `mysqltest1`; |
|
43 |
drop database `mysqltest-1`; |
|
44 |
drop table if exists `txu@0023p@0023p1`; |
|
45 |
drop table if exists `txu#p#p1`; |
|
46 |
create table `txu#p#p1` (s1 int); |
|
47 |
insert into `txu#p#p1` values (1); |
|
48 |
select * from `txu@0023p@0023p1`; |
|
49 |
ERROR 42S02: Table 'test.txu@0023p@0023p1' doesn't exist |
|
50 |
create table `txu@0023p@0023p1` (s1 int);
|
|
51 |
insert into `txu@0023p@0023p1` values (2);
|
|
52 |
select * from `txu@0023p@0023p1`;
|
|
53 |
s1
|
|
54 |
2
|
|
55 |
select * from `txu#p#p1`;
|
|
56 |
s1
|
|
57 |
1
|
|
58 |
drop table `txu@0023p@0023p1`;
|
|
59 |
drop table `txu#p#p1`;
|
|
60 |
truncate t1;
|
|
61 |
drop table t1;
|
|
62 |
drop database if exists `tabc`;
|
|
63 |
drop database if exists `a-b-c`;
|
|
64 |
create database `tabc` default character set latin2;
|
|
65 |
create table tabc.t1 (a int);
|
|
66 |
FLUSH TABLES;
|
|
67 |
show databases like '%a-b-c%'; |
|
68 |
Database (%a-b-c%)
|
|
69 |
#mysql50#a-b-c
|
|
70 |
ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME;
|
|
71 |
show databases like '%a-b-c%'; |
|
72 |
Database (%a-b-c%)
|
|
73 |
a-b-c
|
|
74 |
show create database `a-b-c`;
|
|
75 |
Database Create Database
|
|
76 |
a-b-c CREATE DATABASE `a-b-c` /*!40100 DEFAULT CHARACTER SET latin2 */
|
|
77 |
show tables in `a-b-c`;
|
|
78 |
Tables_in_a-b-c
|
|
79 |
t1
|
|
80 |
show create table `a-b-c`.`t1`;
|
|
81 |
Table Create Table
|
|
82 |
t1 CREATE TABLE `t1` (
|
|
83 |
`a` int(11) DEFAULT NULL
|
|
84 |
) ENGINE=MyISAM DEFAULT CHARSET=latin2
|
|
85 |
drop database `a-b-c`;
|
|
86 |
drop database `tabc`;
|