Re: multiple inserts

["Rolf Hopkins" <rhopkins@xxxxxxxxxxxxxxxxxxx>]

I would think an UPDATE would suit you just fine.

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

----- Original Message -----
From: "fano" <fano@xxxxxxxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
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: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-rhopkins=mail.waytech.com.tw@xxxxxxxxxxxxxxx>
> 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 <mysql-thread67406@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php