multiple inserts

[fano]

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:fa...@servinet.net.ar

---------------------------------------------------------------------
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 <mysql-th...@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=freebsd.csie...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[Rolf Hopkins]

I would think an UPDATE would suit you just fine.

UPDATE mytable SET price=price*1.21 WHERE ...

<mysql-unsubscribe-rhopkins=mail.wayt...@lists.mysql.com>