Question

mysql中查询语句中 as amount 是什么意思？？？

谁能详细解释一下这几句的意思？ $sql="select count(*) as amount from user order by UID asc"; $result=mysql_query($sql); $row=mysql_fetch_row($result); $amount=$row['amount']; 其中不懂的地方是count(*) as amount 还有最后一句。

Answer 1

select count(*) as amount from user order by UID asc
以降序的方式（asc）查询user表里字段为UID的值的数目（count(*)），返回的结果存在别名 amount 里.