|
1
by brian
clean slate |
1 |
select database();
|
2 |
database()
|
|
3 |
test
|
|
4 |
select charset(database());
|
|
5 |
charset(database())
|
|
6 |
utf8
|
|
7 |
select database() = "test";
|
|
8 |
database() = "test"
|
|
9 |
1
|
|
10 |
select database() = _utf8"test";
|
|
11 |
database() = _utf8"test"
|
|
12 |
1
|
|
13 |
select database() = _latin1"test";
|
|
14 |
database() = _latin1"test"
|
|
15 |
1
|
|
16 |
select user() like "%@%";
|
|
17 |
user() like "%@%"
|
|
18 |
1
|
|
19 |
select user() like _utf8"%@%";
|
|
20 |
user() like _utf8"%@%"
|
|
21 |
1
|
|
22 |
select user() like _latin1"%@%";
|
|
23 |
user() like _latin1"%@%"
|
|
24 |
1
|
|
25 |
select charset(user());
|
|
26 |
charset(user())
|
|
27 |
utf8
|
|
28 |
select version()>="3.23.29";
|
|
29 |
version()>="3.23.29"
|
|
30 |
1
|
|
31 |
select version()>=_utf8"3.23.29";
|
|
32 |
version()>=_utf8"3.23.29"
|
|
33 |
1
|
|
34 |
select version()>=_latin1"3.23.29";
|
|
35 |
version()>=_latin1"3.23.29"
|
|
36 |
1
|
|
37 |
select charset(version());
|
|
38 |
charset(version())
|
|
39 |
utf8
|
|
40 |
explain extended select database(), user();
|
|
41 |
id select_type table type possible_keys key key_len ref rows filtered Extra
|
|
42 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
|
|
43 |
Warnings:
|
|
44 |
Note 1003 select database() AS "database()",user() AS "user()"
|
|
45 |
create table t1 (version char(60)) select database(), user(), version() as 'version';
|
|
46 |
show create table t1;
|
|
47 |
Table Create Table
|
|
48 |
t1 CREATE TABLE "t1" (
|
|
49 |
"database()" varchar(34) CHARACTER SET utf8,
|
|
50 |
"user()" varchar(77) CHARACTER SET utf8 NOT NULL,
|
|
51 |
"version" char(60)
|
|
52 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
53 |
drop table t1;
|
|
54 |
select charset(charset(_utf8'a')), charset(collation(_utf8'a'));
|
|
55 |
charset(charset(_utf8'a')) charset(collation(_utf8'a'))
|
|
56 |
utf8 utf8
|
|
57 |
select collation(charset(_utf8'a')), collation(collation(_utf8'a'));
|
|
58 |
collation(charset(_utf8'a')) collation(collation(_utf8'a'))
|
|
59 |
utf8_general_ci utf8_general_ci
|
|
60 |
create table t1 select charset(_utf8'a'), collation(_utf8'a');
|
|
61 |
show create table t1;
|
|
62 |
Table Create Table
|
|
63 |
t1 CREATE TABLE "t1" (
|
|
64 |
"charset(_utf8'a')" varchar(64) CHARACTER SET utf8 NOT NULL,
|
|
65 |
"collation(_utf8'a')" varchar(64) CHARACTER SET utf8 NOT NULL
|
|
66 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
|
67 |
drop table t1;
|
|
68 |
select TRUE,FALSE,NULL;
|
|
69 |
TRUE FALSE NULL
|
|
70 |
1 0 NULL
|
|
71 |
create table t1 (c1 char(5)) character set=latin1;
|
|
72 |
insert into t1 values('row 1');
|
|
73 |
insert into t1 values('row 2');
|
|
74 |
insert into t1 values('row 3');
|
|
75 |
select concat(user(), '--', c1) from t1;
|
|
76 |
concat(user(), '--', c1)
|
|
77 |
root@--row 1
|
|
78 |
root@--row 2
|
|
79 |
root@--row 3
|
|
80 |
select concat(database(), '--', c1) from t1;
|
|
81 |
concat(database(), '--', c1)
|
|
82 |
test--row 1
|
|
83 |
test--row 2
|
|
84 |
test--row 3
|
|
85 |
drop table t1;
|
|
86 |
create table t1 (a char(10)) character set latin1;
|
|
87 |
select * from t1 where a=version();
|
|
88 |
a
|
|
89 |
select * from t1 where a=database();
|
|
90 |
a
|
|
91 |
select * from t1 where a=user();
|
|
92 |
a
|
|
93 |
insert into t1 values ('a');
|
|
94 |
select left(concat(a,version()),1) from t1;
|
|
95 |
left(concat(a,version()),1)
|
|
96 |
a
|
|
97 |
drop table t1;
|