Paul,
I mean to say that it USED two different databases..
By the way, I could use mysql at the dos prompt. And I could use mysql -u
root -p at the dos prompt, too. It looks like I could do almost anything at
the c:\ prompt.
Thanks again.
----- Original Message -----
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 25, 2002 12:56 PM
Subject: Re: Table created on script Err
> At 12:35 -0500 3/25/02, alan4100 wrote:
> >Paul,
> >
> >You are right. :)
> >
> >USE alan03 works.
> >USE db_alan03 works.
> >
> >But it created two separate databases. They are not the same. But both
> >works just the same.
>
>
> That doesn't make any sense. USE doesn't create anything.
>
> >
> >
> >
> >----- Original Message -----
> >From: "Paul DuBois" <[EMAIL PROTECTED]>
> >To: "alan4100" <[EMAIL PROTECTED]>; "Gerald Clark"
> ><[EMAIL PROTECTED]>
> >Cc: <[EMAIL PROTECTED]>
> >Sent: Monday, March 25, 2002 10:56 AM
> >Subject: Re: Table created on script Err
> >
> >
> >> At 10:40 -0500 3/25/02, alan4100 wrote:
> >> >mysql
> >> >
> >> >Gerald,
> >> >
> >> >I will try that; Paul had suggested USE db_name. ..I will try both
> >ways..USE
> >> >db2 and USE db_xxx .. Will keep you both posted.
> >>
> >> Gerald's suggestion and mine are the *same*: The "USE" keyword
followed by
> >> the name of the database you want to use.
> >>
> >> >
> >> >----- Original Message -----
> >> >From: "Gerald Clark" <[EMAIL PROTECTED]>
> >> >To: "alan4100" <[EMAIL PROTECTED]>
> >> >Cc: <[EMAIL PROTECTED]>
> >> >Sent: Monday, March 25, 2002 9:37 AM
> >> >Subject: Re: Table created on script Err
> >> >
> >> >
> >> >> USE db2;
> >> >>
> >> >> alan4100 wrote:
> >> >>
> >> >> >mysql
> >> >> >
> >> >> >Paul,
> >> >> >
> >> >> >I was afraid to hear that. It had said about line 2 in the error
> >message.
> >> >> >This line #2 looks normal.
> >> >> >
> >> >> >May I ask you to check this script below, but I am afraid it may
be
> >> >> >annoying. I will eventually put this on posting. Remember I use
> >Windows
> >> >XP.
> >> >> >
> >> >> >I would like to know if there is such an mysql "reader" to check
> >syntax
> >> >> >before I run the script. I am using MySQL by Sams in 21 days.
> >> >> >
> >> >> >Alan
> >> >> >
> >> >> >
> >> >> >
> >> >> >==========================================
> >> >> >
> >> >> >CREATE db db2;
> >> >> >USE db db2;
> >> >> >CREATE TABLE Customers (Customer_ID INT NOT NULL
> >> >> >PRIMARY KEY AUTO_INCREMENT, First_Name VARCHAR(20)
> >> >> >NOT NULL,Last_Name VARCHAR(30) NOT NULL,
> >> >> >Address VARCHAR(50), City VARCHAR(20),
> >> >> >State VARCHAR(2), Zip VARCHAR(20),
> >> >> >E_Mail VARCHAR(20), Age INT, Race VARCHAR(20),
> >> >> >Gender ENUM('M','F') DEFAULT 'F',
> >> >> >Eye_Color VARCHAR(10), Hair_Color VARCHAR(10),
> >> >> >Favorite_Activity ENUM('Programming', 'Eating',
> >> >> >'Biking', 'Running', 'None') DEFAULT 'None',
> >> >> >Favorite_Movie VARCHAR(50), Occupation VARCHAR(30),
> >> >> >Smoker Char(0));
> > > > > >
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
