I would think an UPDATE would suit you just fine.
UPDATE mytable SET price=price*1.21 WHERE ...
----- Original Message -----
From: "fano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 23:01
Subject: multiple inserts
> Hello mysql,
>
> Hi, I have a table "Invoices", and i want to do something like
> this..
> every 15 of every month, i need to open every registry of invoices..
> take the price of each record and crete a new record with that price
> * 1.21 (I'm from argentina, and we pay some taxez :)
> How can i do this?
> i think set @variables wiil be a good idea.. but how can i use set
> with 190 records?
> i dont know how to do it...
> Thanks
>
> --
> Best regards,
> fano mailto:[EMAIL PROTECTED]
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
