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]
- Re: [PHP-DB] sql problem Fai
- Re: [PHP-DB] sql problem Hugh Bothwell
- RE: [PHP-DB] sql problem Mats Remman
- Re: [PHP-DB] sql problem Doug Semig
- [PHP-DB] SQL problem Robert Vukovic
- RE: [PHP-DB] SQL problem Robert Vukovic
- Re: [PHP-DB] SQL problem Dobromir Velev
- RE: [PHP-DB] SQL problem Robert Vukovic
- [PHP-DB] sql problem its me