Re: Move data from one MySql table to another?
| From: | almir | Date: | Sat, 24 Mar 2001 23:46:05 +0000 |
| Subject: | Re: Move data from one MySql table to another? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-45459@lists.php.net to get a copy of this message | ||
write
insert into new_table (val1, val2)
select from old_table
val1, val2 where id=kdsaflkj
and execute it with php like any other statement
almir
ps. but checking mysql.com helps, there are lot of other interesting things
""YoBro"" <nospam@brochures.co.nz> schrieb im Newsbeitrag
news:99e1q7$gv8$1@toye.p.sourceforge.net...
> I need to know how to do it in PHP?
>
>
> ""Cal Evans"" <cal@calevans.com> wrote in message
> news:NABBLCCEONHNHBGBBPHPIEABAMAB.cal@calevans.com...
> : Probably on the MySQL list. This is the PHP. (This is arguments,abuse
is
> : down the hall.)
> :
> : Try:
> : http://www.mysql.com/documentation/lists.html
> :
> :
> : Cal
> : http://www.calevans.com
> :
> :
> : -----Original Message-----
> : From: YoBro [mailto:nospam@brochures.co.nz]
> : Sent: Thursday, March 22, 2001 5:20 PM
> : To: php-general@lists.php.net
> : Subject: [PHP] Move data from one MySql table to another?
> :
> :
> : Hello,
> :
> : Does anybody know where I could find out how to Move data from one Mysql
> : table to another.
> :
> : I have a query showing all the results, and I am trying to put a link at
> the
> : end of each row that says "move"
> :
> : Clicking this will move that records information to another table.
> : IE From table orders to table ordered
> :
> : Make sense?
> :
> : Please help
> :
> : --
> : Regards,
> :
> :
> : YoBro
> : -------------------------------------------------------------
> : DO NOT REPLY TO THIS VIA EMAIL
> : PLEASE USE THE NEWSGROUP
> : All emails sent to this address are automatically deleted.
> : This is to avoid SPAM!
> : -------------------------------------------------------------
> :
> :
> :
> : --
> : PHP General Mailing List (http://www.php.net/)
> : To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> : For additional commands, e-mail: php-general-help@lists.php.net
> : To contact the list administrators, e-mail: php-list-admin@lists.php.net
> :
> :
> :
> : --
> : PHP General Mailing List (http://www.php.net/)
> : To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> : For additional commands, e-mail: php-general-help@lists.php.net
> : To contact the list administrators, e-mail: php-list-admin@lists.php.net
> :
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>