Re: newbie Q: create a table in a database

[Leonardo Rodrigues Magalhães]

    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]