List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 7 2001 2:20am
Subject:Re: Drop table problem
View as plain text  
At 6:46 PM -0700 10/6/01, Rosyna wrote:
>ERROR: Query failed (You have an error in your SQL syntax near 
>'create table Student
>(
>	Student_ID	int auto_increment not null,
>	Student_FName	v' at line 1)
>
>Ack, at 10/6/01, Paul DuBois said:
>
>>And the error message that you get is ... ?
>
>--
>Sincerely,
>Rosyna Keller
>Technical Support/Holy Knight/Always needs a hug
>
>Unsanity: Unsane Tools for Insane People

I take it, then, that you're issuing the DROP TABLE and CREATE
TABLE statements from within mysql.  You need to add a semicolon
after each statement.

-- 
Paul DuBois, paul@stripped
Thread
problem running mySQL installed by rpm on linux RH7Harry Sices6 Oct
  • RE: problem running mySQL installed by rpm on linux RH7Mike6 Oct
    • Drop table problemRosyna6 Oct
      • Re: Drop table problemPaul DuBois7 Oct
        • Re: Drop table problemRosyna7 Oct
          • Re: Drop table problemPaul DuBois7 Oct
      • RE: Drop table problemJoe Kaiping7 Oct