mysql中相关量表的sql语句操作
mysql里有两个表，member(id,memberName)和record(id,memberId)memberId就是member表里id
我的目的是选出 member表里的全部memberName，然后按record表里的记录数来排序,我写了下面这个语句，但我发现一个很大的漏洞就是如果这个memberName在record表里无记录的话，那也就不能取出了，有没有别的什么办法写这样一个sql，把member里的所有记录都取出来，当然要按record里的记录多少，由高到低的排序
select a.memberName,count(*) from member a,record b
where a.id = b.memberId
group by a.memberName
order by count(*) desc
select a.memberName,count(*) from member a
left join record b
on a.id = b.memberId
group by a.memberName
order by count(*) desc
防止memberName重复的情况，应该这样写：
SQL code:
select a.id,a.memberName,count(b.id) as total_count
from member a
left join record b
on a.id = b.memberId
group by a.id
order by total_count desc
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'record b on a.id = b.memberId group by a.id order by total' at line 2
按你这个说话 我有错误提示
select a.id,a.memberName,count(b.id) as total_count
from member a
left join record b
on a.id = b.memberId
group by a.id,a.memberName
order by t
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
原数据
商品 原价 打折方式1 折扣1 打折方式2 折扣2
笔记本 10000 NULL 0 NULL&nb ......
我以前安装了一次，后来卸载了，现在再安装的时候，提示错误：Error 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
� ......
我现在学习MYSQL，问下mysql储存过程如何建立和使用，最好写成$sql="sql语句",$re=mysql_query($sql);谢谢
建议你先自己看一下文档中的例子。
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
如题 数据是BLOB类型 怎么才能修改其中的某些值
BLOB中存入的是什么内容？
假设字段memo为blob类型，在该字段的值前面增加字符串'add--'
则操作语句如下：
SQL code:
update tb_blog set memo=concat( ......
