Several strategies come to mind. You could do a sql dump of the table
structure and data and then import it in the new database. Or use
myPHPadmin which has functions to transport (MOVE or COPY) a data table
from one database to another.
I suppose the first option is best if you need a programmatical approach.
All the best
Pierre
Liu Qianghua-qch1942 wrote:
> Hi, all
>
> My mysql version is 3.23.36. I want to transfer some data from the table 'paid' which
> belongs to database 'user' into new tables 'pay' which belongs to another database
> 'vip_user'. What should I do? Thanks a lots.
>
> Best Regards,
>
> Q.H Liu
>
> ---------------------------------------------------------------------
> 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-thread113817@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-pierre=finalfiler.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
Pierre du Parté
Final Filer Software
349 Worrigee Road
Worrigee, NSW, Australia 2540
http://www.finalfiler.com
Phone 61 2 44216374
Mobile 0413 483 066
"If it feels good, do it!"
