通过sql语句如何检测到数据库的名字-理会精神

最新推荐文章于 2023-03-29 13:18:18 发布

牙小木

最新推荐文章于 2023-03-29 13:18:18 发布

阅读量592

点赞数

分类专栏： mysql 文章标签：数据库 sql select ascii

本文链接：https://blog.csdn.net/tstbdt/article/details/44338157

版权

mysql 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

当然一句话就可以搞定

select database（）;

but the main idea is the way of thinking.

mysql> select length("ac");
+--------------+
| length("ac") |
+--------------+
|            2 |
+--------------+
1 row in set

mysql> select length(database());
+--------------------+
| length(database()) |
+--------------------+
|                  6 |
+--------------------+
1 row in set

mysql> select database();
+------------+
| database() |
+------------+
| aldapp     |
+------------+
1 row in set

mysql> select ASCII('A');
+------------+
| ASCII('A') |
+------------+
|         65 |
+------------+
1 row in set

mysql> Select ascii(substr(database(),2,1)) = 101;
+-------------------------------------+
| ascii(substr(database(),2,1)) = 101 |
+-------------------------------------+
|                                   0 |
+-------------------------------------+
1 row in set

mysql> Select ascii(substr(database(),2,1))=69;
+----------------------------------+
| ascii(substr(database(),2,1))=69 |
+----------------------------------+
|                                0 |
+----------------------------------+
1 row in set

mysql> Select (substr(database(),2,1));
+--------------------------+
| (substr(database(),2,1)) |
+--------------------------+
| l                        |
+--------------------------+
1 row in set

mysql> Select ascii(substr(database(),2,1));
+-------------------------------+
| ascii(substr(database(),2,1)) |
+-------------------------------+
|                           108 |
+-------------------------------+
1 row in set

mysql> select ASCII('a');
+------------+
| ASCII('a') |
+------------+
|         97 |
+------------+
1 row in set

mysql> select ASCII('l');
+------------+
| ASCII('l') |
+------------+
|        108 |
+------------+
1 row in set

mysql> 第二个为l，因为数据库名ald***

mysql> Select ascii(substr(database(),2,1))=108;
+-----------------------------------+
| ascii(substr(database(),2,1))=108 |
+-----------------------------------+
| 1 |
+-----------------------------------+

正确返回1

mysql> Select if((select database())='aldapp',1,2);
+--------------------------------------+
| if((select database())='aldapp',1,2) |
+--------------------------------------+
| 1 |
+--------------------------------------+
1 row in set

正确返回1