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 table1.column2=tableA.column2 AND table1.column3=tableB.column2 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. On Friday, August 2, 2002, at 09:35 AM, adi 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 > > --------------------------------------------------------------------- > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php