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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
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 manually,
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
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