List:General Discussion« Previous MessageNext Message »
From:Dicky Wahyu Purnomo Date:July 5 2002 1:55am
Subject:Re: transfer data in mysql
View as plain text  
Pada Fri, 5 Jul 2002 09:24:22 +0800 
Liu Qianghua-qch1942 <qiang-hua.liu@stripped> menulis :

> 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.


you can do this :

mysql> create table vip_user.pay select user.* from user.paid; 

sql,query
-- 
/* So there I am, in the middle of my `netfilter-is-wonderful'
   talk in Sydney, and someone asks `What happens if you try
   to enlarge a 64k packet here?'.  I think I said something
   eloquent like `fuck'. */
        2.4.3 linux/net/ipv4/netfilter/ip_nat_ftp.c
 
MySQL 3.23.51 : up 13 days, Queries : 381.039 per second (avg).
Thread
RE: transfer data in mysqlLiu Qianghua-qch19425 Jul
  • Re: transfer data in mysqlPierre du Parte5 Jul
  • Re: transfer data in mysqlDicky Wahyu Purnomo5 Jul
  • Porting from GUPTA-SQL client to PHP - SQL client.Luis Manuel Cova5 Jul