re-submitted : re-send : Hi, you can use mysql variables :
set @total:=0; select name,price,quantity, price*quantity as subtotal,@total:[EMAIL PROTECTED] from fruits; +--------+-------+----------+----------+-------------------------------+ | name | price | quantity | subtotal | @total:[EMAIL PROTECTED] | +--------+-------+----------+----------+-------------------------------+ | orange | 1 | 2 | 2 | 2 | | banana | 1 | 4 | 4 | 6 | +--------+-------+----------+----------+-------------------------------+ The total column will be incremented by subtotal in each row. Mathias > > Selon Philip George <[EMAIL PROTECTED]>: > > > > > actually, i've decided this is sort of a moot point, since i can do > > > this calculation in the client app. > > > > > > no sql required. > > > > > > thanks. > > > > > > - philip > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
