我在WinNT和RedHad Linux下都执行过了,没有问题。mysql 3.23.49-nt for Winnt,mysql 3.23.36 for linux。下面是我测试过程:
mysql> create table if not exists tests(users varchar(10) binary not null,passwd
varchar(50) binary not null);
Query OK, 0 rows affected (0.04 sec)mysql> insert into tests values ('webmin',md5('12345'));
Query OK, 1 row affected (0.01 sec)mysql> select * from tests;
+--------+----------------------------------+
| users | passwd |
+--------+----------------------------------+
| webmin | 827ccb0eea8a706c4c34a16891f84e7b |
+--------+----------------------------------+
1 row in set (0.00 sec)mysql> select * from tests where passwd = md5('12345');
+--------+----------------------------------+
| users | passwd |
+--------+----------------------------------+
| webmin | 827ccb0eea8a706c4c34a16891f84e7b |
+--------+----------------------------------+
1 row in set (0.00 sec)
mysql> create table if not exists tests(users varchar(10) binary not null,passwd
varchar(50) binary not null);
Query OK, 0 rows affected (0.04 sec)mysql> insert into tests values ('webmin',md5('12345'));
Query OK, 1 row affected (0.01 sec)mysql> select * from tests;
+--------+----------------------------------+
| users | passwd |
+--------+----------------------------------+
| webmin | 827ccb0eea8a706c4c34a16891f84e7b |
+--------+----------------------------------+
1 row in set (0.00 sec)mysql> select * from tests where passwd = md5('12345');
+--------+----------------------------------+
| users | passwd |
+--------+----------------------------------+
| webmin | 827ccb0eea8a706c4c34a16891f84e7b |
+--------+----------------------------------+
1 row in set (0.00 sec)
解决方案 »
- Mysql如何获得系统当前时间的后一天?
- 查询任意日期同一周的记录语句
- 我的mysql数据库现在只有.frm文件了,我直接复制到新的mysql/data目录下面,确总是报表不存在错误
- Show master Status在master和Slava机器上结果不一样
- 请教一数据库结构
- 求mysql 客户端开发工具
- 请教mysql-jdbc3-beta编程问题??
- mysql水平分区问题
- MySQL创建用户不能登录问题,如图
- 想通过应用程序备份mysql ,mysql有这样的调用接口吗?如果不用脚本
- 在xp下安装MYSQL失败!
- 如何把一个文件放进mysql 库里?insert 语句怎么用?如何读出数据(文件)?
用SELECT PASSWD,MD5('12345') FROM TESTS看一下比较结果
可能是PASSWD不够宽, MD5有32个字符