[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