AW: [PHP] how can copy a table's data of a datebase to another ?
| From: | Moritz Petersen | Date: | Thu, 04 Jan 2001 17:56:46 +0000 |
| Subject: | AW: [PHP] how can copy a table's data of a datebase to another ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-32674@lists.php.net to get a copy of this message | ||
I'm not sure, but the simple SQL-Statement:
mysql_query("INSERT INTO db1.table_copy SELECT * FROM db2.table_origin");
should do the job.
Mo.
> -----Ursprüngliche Nachricht-----
> Von: Bass¨Ð¦õªv [mailto:98350193j@polyu.edu.hk]
> Gesendet: Donnerstag, 4. Januar 2001 12:17
> An: php-general@lists.php.net
> Betreff: [PHP] how can copy a table's data of a datebase to another ?
>
>
> hi,
> do anyone know how can copy a table's data of a datebase to another ?
> for example
> Table A of database A to Table B of datebase B
> but the datebase are on DIFF computer
> maybe one at HK office and the other at Kowloon
>
> How to do ?
> can it do by PHP ?
> THX
>
>
>
>
> --
> 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
>