看板FreeBSD
标 题Re: [问题] 请问MYSQL的问题
发信站SayYA 资讯站 (Sat Sep 10 10:05:33 2005)
转信站ptt!ctu-reader!news.nctu!SayYa
※ 引述《[email protected] (燃烧的K66版)》之铭言：
> 请问一下 我的mysql是 4.1.14
> mysql> update users set passwd=PASSWORD('8716') where username='donkey';
> Query OK, 1 row affected, 1 warning (0.02 sec)
> Rows matched: 1 Changed: 1 Warnings: 1
> mysql> select * from users where pass='8716';
> | username | passwd | pass
> +------------+-----------------+-----+
> | donkey | 35466c380c9e911 | 8716
> 1 row in set (0.02 sec)
> mysql> select * from users where passwd=PASSWORD('8716');
> Empty set (0.01 sec)
> 请问要怎麽下指令才抓得到PASSWORD('8716')呢? 谢谢
照你的版本来看
mysql> select password('8716');
+-------------------------------------------+
| password('8716') |
+-------------------------------------------+
| *51CEDF42C0F7D39006E744EF86C76CEA8AED5F50 |
+-------------------------------------------+
1 row in set (0.00 sec)
栏位储存长度请设到 varchar(41) 左右
这样比对就不会出问题了...
--
Best Regards,
Johnney Huang (
[email protected])
--
※ Origin: SayYA 资讯站 <bbs.sayya.org>
◆ From: ics.nccu.edu.tw