> As long as two databases are on the same disk you can also rename from one
> database to another:
> RENAME TABLE current_db.tbl_name TO other_db.tbl_name;


Works!! :-)   But the thing is: by doing this, although the tables have been
*moved* from the old database to the new one, the old database still exists
and I'll have to drop it separately.  -------- So, this should NOT be called
*rename*. The procedures involved are: create a new database -> move the
tables from the old_database to the new_database.  Funny. :-)

thanks Heikki.







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to