show create table database.tablename
desc database.tablename
you can use database.tablename in SEVERAL places .....
insert into database.tablename values ( ) ......
select from database.tablename where .......
select from database1.tablename1 A, database2.tablename2 B .....
update database.tablename ........
delete from database.tablename .......
drop table database.tablename ......
I'm not a MySQL expert, but I think almost all places that a tablename
is required, database.tablename can be used .....
Sincerily,
Leonardo Rodrigues
----- Original Message -----
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Leonardo Rodrigues Magalhães" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 9:51 AM
Subject: Re: newbie Q: create a table in a database
> That's cool, Leonardo. Thanks.
>
> BTW, how can I show the structure of the table without 'changing' to that
> database?
> ----- 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]
