Re: sql problem
| From: | Hugh Bothwell | Date: | Tue, 26 Jun 2001 04:12:24 +0000 |
| Subject: | Re: sql problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9820@lists.php.net to get a copy of this message | ||
""Fai"" <fai5@hknet.com> wrote in message
news:9h90l2$1op$1@w153.z064000151.sjc-ca.dsl.cnc.net...
> SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
> UPDATE table2 SET summmary=@A WHERE type=1;
>
> What does @A: mean?
>
> Thank you very much!
They're writing the sum to an SQL variable.