Re: how to make multiple in a coloum in mysql DB
| From: | Markus Lervik | Date: | Wed, 06 Mar 2002 08:20:47 +0000 |
| Subject: | Re: how to make multiple in a coloum in mysql DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17502@lists.php.net to get a copy of this message | ||
On Wed, 2002-03-06 at 10:02, Yoga Anak Medan wrote:
> salam,
> i'm make a database in mysql, example :
> name score A score A Total
> john 78 90
> mike 90 70
> etc...
> ask me is:
> how to make multiple or total in coulum "Total"
> otomatically, if me input score in coulom total.
> please help me...
> (i am sorry my english)
INSERT INTO table VALUES("john", "78", "90", scoreA+scoreB);
Cheers,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
markus.lervik@vaasa.fi
+358-6-325 3589 / +358-40-832 6709