- 博客(2)
- 收藏
- 关注
原创 mysql身份验证
MySQL的身份认证协议是一种CHAP协议,即,挑战应答。S->C : public_seedC->S: username, replyS->C: Ok or error对于4.1及以后版本,public_seed是随机生的20个可打印的ASCII字符然后客户端这么计算reply:passphrase=sha1("password")storedhash=sha1(passphr...
2013-09-18 17:30:27
405
原创 MySQL不支持INTERSECT和MINUS,及其替代方法
Doing INTERSECT and MINUS in MySQL Doing an INTERSECTAn INTERSECT is simply an inner join where we compare the tuples of one table with those of the other, and select those that appear in ...
2013-09-18 09:25:14
270
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人