sql | “弱类型” | 隐匿转换

最新推荐文章于 2022-04-11 20:33:40 发布

JacobTsang

最新推荐文章于 2022-04-11 20:33:40 发布

阅读量349

点赞数 1

分类专栏： Information Security

本文链接：https://blog.csdn.net/weixin_41594045/article/details/102489950

版权

Information Security 专栏收录该内容

49 篇文章 5 订阅

订阅专栏

mysql> desc users;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(3)      | NO   | PRI | NULL    | auto_increment |
| username | varchar(20) | NO   |     | NULL    |                |
| password | varchar(20) | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> select * from users;
+----+----------+------------+
| id | username | password   |
+----+----------+------------+
|  1 | Dumb     | Dumb       |
|  2 | Angelina | I-kill-you |
|  3 | Dummy    | p@ssword   |
|  4 | secure   | crappy     |
|  5 | stupid   | stupidity  |
|  6 | superman | genious    |
|  7 | batman   | mob!le     |
|  8 | admin    | admin      |
|  9 | admin1   | admin1     |
| 10 | admin2   | admin2     |
| 11 | admin3   | admin3     |
| 12 | dhakkan  | dumbo      |
| 14 | admin4   | admin4     |
+----+----------+------------+
13 rows in set (0.00 sec)

mysql> SELECT * FROM users WHERE id='11';
+----+----------+----------+
| id | username | password |
+----+----------+----------+
| 11 | admin3   | admin3   |
+----+----------+----------+
1 row in set (0.00 sec)

mysql> SELECT * FROM users WHERE id=11;
+----+----------+----------+
| id | username | password |
+----+----------+----------+
| 11 | admin3   | admin3   |
+----+----------+----------+
1 row in set (0.00 sec)

mysql> SELECT * FROM users WHERE id='11abcde';
+----+----------+----------+
| id | username | password |
+----+----------+----------+
| 11 | admin3   | admin3   |
+----+----------+----------+
1 row in set, 1 warning (0.00 sec)