[PerlChina] 有个SQL 查询,出错了。着急问一下结果

rorot yang.liana at gmail.com
Wed Dec 3 22:33:51 PST 2008


不好意思,着急用。刚才在SQL IRC里没人回答。所以发这里,望有人解决一下。

SELECT (unix_timestamp(now()) - unix_timestamp(starttime)) as diff  FROM
`workers` WHERE diff < 900;

上面这条MySQL查询为什么出错??

*MySQL said: *[image:
Documentation]<http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html>
 #1054 - Unknown column 'diff' in 'where clause'



rorot Dec/04/2008
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/china-pm/attachments/20081204/5eb22701/attachment.html>


More information about the China-pm mailing list