List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:March 25 2002 2:37pm
Subject:Re: Table created on script Err
View as plain text  
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