multiple inserts

[fano <fano@xxxxxxxxxxxxxxx>]

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:fano@xxxxxxxxxxxxxxx





---------------------------------------------------------------------
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-thread67323@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php