That's cool, Leonardo. Thanks. BTW, how can I show the structure of the table without 'changing' to that database?
cheers, feng ----- Original Message ----- From: "Leonardo Rodrigues Magalhães" <[EMAIL PROTECTED]> To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 10:27 PM Subject: Re: newbie Q: create a table in a database > > You can create a table in any database without 'changing' to that > database, via USE or logging again. You can make > > create table database.tablename (tabledefinition); > > > > > >c:\mysql\bin\mysql --------line 1 > > mysql>create database DB1 --------line 2 > mysql>create table DB1.TB1(id char(3)); -------line 3 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]