List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 25 2002 5:56pm
Subject:Re: Table created on script Err
View as plain text  
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" <paul@stripped>
>To: "alan4100" <alan4100@stripped>; "Gerald Clark"
><gerald_clark@stripped>
>Cc: <mysql@stripped>
>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" <gerald_clark@stripped>
>>  >To: "alan4100" <alan4100@stripped>
>>  >Cc: <mysql@stripped>
>>  >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));
>  > >  > >

Thread
Table created on script Erralan410024 Mar
  • Re: Table created on script ErrPaul DuBois24 Mar
Re: Table created on script Erralan410025 Mar
  • Re: Table created on script ErrGerald Clark25 Mar
  • Re: Table created on script Erralan410025 Mar
    • Re: Table created on script ErrPaul DuBois25 Mar
  • Re: Table created on script Erralan410025 Mar
  • Re: Table created on script Erralan410025 Mar
    • Re: Table created on script ErrPaul DuBois25 Mar
  • Re: Table created on script Erralan410026 Mar