RE: [PHP] how to avoid using temporary?
| From: | Tommy Pham | Date: | Tue, 18 Jan 2011 09:43:56 +0000 |
| Subject: | RE: [PHP] how to avoid using temporary? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-310830@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: I am on the top of the world! Borlange University
> [mailto:michael3832628@gmail.com]
> Sent: Monday, January 17, 2011 11:33 PM
> To: php-general@lists.php.net
> Subject: [PHP] how to avoid using temporary?
>
> heres my sql query:
> EXPLAIN SELECT t1.szs_guige,SUM(t1.szs_shuliang) FROM szs_ck_ruku_items
> t1,szs_ck_ruku t2 WHERE t1.szs_rukubianhao = t2.szs_rukubianhao AND
> t2.szs_date>'2010-10-23' GROUP BY t1.szs_guige ORDER BY null
>
<snip>
This is PHP list. Not a SQL list/discussion. Try asking the forum relating
to the DBMS you're using.
Regards,
Tommy