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
