List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 6 1999 6:47pm
Subject:Re: Newbie Problem
View as plain text  
At 10:40 AM -0800 11/6/99, srhcpa@stripped wrote:
>I am trying to handle some administrative issues with a MySQL 
>database on a Unix server.  The server has given me a CGI script 
>that I can access the database which is called dbsomething.  After I 
>am able to log in through my browser I cannot access the database 
>with any other commands.
>For example, when I input the following into the SQL command area of 
>the script:
>INSERT INTO user (host, user,) VALUES('srh', 'test');
>I get:
>sql(): Errorparse error near ') VALUES('srh', 'test');' at line 1

Naturally.  You have an extra comma after "user" in the column list.
Instead of this:

INSERT INTO user (host, user,) VALUES('srh', 'test');
                             note the comma there
Use this:

INSERT INTO user (host, user) VALUES('srh', 'test');

Paul DuBois, paul@stripped
Re: Newbie Problemsrhcpa6 Nov
  • Re: Newbie ProblemPaul DuBois6 Nov
  • Re: Newbie ProblemBob Kline6 Nov
  • Re: Newbie Problemsinisa7 Nov