[转载] mysql database question# Database - 数据库
c*d
1 楼
【 以下文字转载自 Linux 讨论区 】
【 原文由 cyberwind 所发表 】
老枪也有卡壳的时候哈:
mysql> update db.table set Password=md5("test") where -> Username="Administrator";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> SELECT * FROM db.table WHERE Username = 'Administrator' AND Password ='MD5("test")';
Empty set (0.00 sec)
mysql> SELECT * FROM db.table WHERE Username = 'Administrator';
+---------------+----------------------------------+
| Username | Password |
+
【 原文由 cyberwind 所发表 】
老枪也有卡壳的时候哈:
mysql> update db.table set Password=md5("test") where -> Username="Administrator";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> SELECT * FROM db.table WHERE Username = 'Administrator' AND Password ='MD5("test")';
Empty set (0.00 sec)
mysql> SELECT * FROM db.table WHERE Username = 'Administrator';
+---------------+----------------------------------+
| Username | Password |
+