commandPrompt> USE DataBaseName;
Thanks
Emery
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 10:55
Subject: newbie Q: create a table in a database
> Hi, folks.
>
> I use Windows XP Pro, MySQL v.1.4
>
> The following i
igues
- 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
t;; <[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
>
> cr
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 DB1line 2
mysql>cre
Neculai, thanks. That answers my question.
cheers,
feng
- Original Message -
From: "Neculai Macarie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 8:01 PM
Subject: Re: newbie Q: create a table in a database
&
> >c:\mysql\bin\mysql line 1
> mysql>create database DB1line 2
mysql>use DB1;
> mysql>create table TB1(id char(3)); ---line 5
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, Septemb