that was preety good..
merged 3 tables with 2 million raws in 3 minutes...
thanks
FB
"Sean Burlington" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> FB wrote:
> > Hi,
> >
> > I have 3 similar tables. I want to merge them. The thing I use is
> >
> > 1) SELECT *
> > 2) Make a whil
FB wrote:
Hi,
I have 3 similar tables. I want to merge them. The thing I use is
1) SELECT *
2) Make a while statement
3) INSERT each raw into the other table
is there a easier way?
FB
if the columsn are identical
insert into table1 select * from table2;
insert into table1 select * from table3;
Hi,
I have 3 similar tables. I want to merge them. The thing I use is
1) SELECT *
2) Make a while statement
3) INSERT each raw into the other table
is there a easier way?
FB
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php