At 10:40 AM -0800 11/6/99, srhcpa@stripped wrote:
>Hi,
>
>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
