MySQL
iteye_8239
这个作者很懒,什么都没留下…
展开
-
MySQL修改密码
mysql> 状态下输入 update user set password=password('新密码') where user='root';回显 Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql> 状态下输入 FLUSH PRIVILEGES; 回显 Qu...原创 2009-12-05 16:59:53 · 85 阅读 · 0 评论 -
Navicat 8.2注册码
Navicat 8.2 for MySQL的注册码:PremiumSoft Navicat for MySQL Enterprise Edition v8.XX姓名(Name):3ddown.com组织(Organization):3ddown.com注册码(Serial):NAVJ-W56S-3YUU-MVHV原创 2010-01-26 12:42:03 · 2614 阅读 · 1 评论 -
SQL语句中使用rand()和round()函数
update user set user_id = Round(RAND() * 100, 0)原创 2011-05-22 00:06:56 · 2939 阅读 · 0 评论 -
group by & count()
select count(*) as C,average_fitness from alpha_average_fitness group by average_fitness order by C desc原创 2011-06-10 01:19:10 · 80 阅读 · 0 评论 -
tcat查看频数
select count(*) as I,average_fitness from alpha_average_fitness where alpha原创 2011-06-20 11:43:28 · 118 阅读 · 0 评论 -
把A字段有两条以上的相同记录选出来
select * from tablename where a in (select uid from user group by uid having count(uid)> 1 )原创 2011-05-14 00:47:36 · 182 阅读 · 0 评论