List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 18 1999 12:05am
Subject:Re: newbie question #2
View as plain text  
On Fri, 1999-09-17 15:09:57 -0400, Steven T. Sigourney wrote:
> So I am going through the webmonkey tutorial trying to create a
> table in my database with this command:
> CREATE TABLE employees (  id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
> first varchar(20),  last varchar(20),  address varchar(255),  position
> varchar(50),  PRIMARY KEY (id),  UNIQUE id (id));INSERT INTO employees
> VALUES (1,'Bob','Smith','128 Here St, Cityname','Marketing Manager');

This are two seperate SQL statements: a CREATE and an INSERT.
How did you execute this SQL statements?

Your error message ...

> but, I get this error:
> 
> sql_out:
> 
> --------------
> CREATE TABLE employees
> --------------
> 
> ERROR: parse error near '' at line 1

does show me, that it's not the 'mysql" monitor program, but some
other interface.

Maybe this interface (whatever it may be) doesn't allow you to issue
more than one SQL statement at once?  Just guessing, because you
didn't provide enough information ...

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
newbie question #2Steven T. Sigourney17 Sep
  • Re: newbie question #2Martin Ramsch18 Sep