On Tue, Mar 20, 2001 at 10:03:34AM +0100, Fred van Engen wrote:
> Third:
>
> RENAME TABLE tbl_name TO new_table_name;
>
> (see http://www.mysql.com/doc/R/E/RENAME_TABLE.html )
>
> Fourth:
>
> ALTER TABLE tbl_name RENAME [TO] new_table_name;
>
> (see http://www.mysql.com/doc/A/L/ALTER_TABLE.ht
On Tue, Mar 20, 2001 at 08:27:39AM +0100, René Tegel wrote:
> copying tables between databases:
>
> create table db2.table2 select * from db1.table1;
>
> however, you'll loose meta data (indexes) on this table, so you'd have to
> create them again.
>
> second method:
> use the explorer or a dos
copying tables between databases:
create table db2.table2 select * from db1.table1;
however, you'll loose meta data (indexes) on this table, so you'd have to
create them again.
second method:
use the explorer or a dos shell to rename any table or db as shown in the
\mysql\bin directory. From wi
