At 10:40 -0500 3/25/02, alan4100 wrote:
>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" <gerald_clark@stripped>
>To: "alan4100" <alan4100@stripped>
>Sent: Monday, March 25, 2002 9:37 AM
>Subject: Re: Table created on script Err
>> USE db2;
>> alan4100 wrote:
>> >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
>> >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.
>> >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));
> > >