@a is here an internal 'session' variable used in sql databases (atleast
mysql).
simple usage :
select @a:=1;
-> 1
select @b:=10;
-> 10
select @a + @b;
-> 11
These variables are used to hold temporary numbers and characters, so the
interaction between the script language and the database can be held to a
minimum.
Mats Remman
PHP Developer, MySQL DBA
Coretrek, Norway
+47 51978591 / +47 91623566
> -----Original Message-----
> From: Fai [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 26, 2001 5:55 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] sql problem
>
>
> 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!
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
