Brent
> Don't know if that's what you are trying to do. But I can't think of any
> reason to permanently replicate a table in the same database.
Maybe the other person is duplicating the data to do test stuff to it...
mysql,query
[I hope the spam thing lets this through]
DSL
--
We are not
Why would you want to replicate your data in the same location on the
same machine?
You can use an alias name if you need to join a table multiple times in
a select. Something like this:
select table1.column1,tableA.columnA,tableB.columnA
from table1,table2 as TableA, table2 asTableB
where tab
On Fri, 02 Aug 2002 16:35:11 +0300
adi <[EMAIL PROTECTED]> wrote:
> How to make a table(table2) with same content of existing table(table1) in
> same database(database1) with mysql?
> tx in adv for any help
> adi
create table table2 as select * from table1;
You will have to create indexes manual
