Mailing List Archive


Back to the month index Back to the list index
Petros Dourouklakis (petros@redsnapper.net)
Fri, 03 Jan 1997 13:30:35 +0000 

Message-Id: <32CD09FB.704C@redsnapper.net>
Date: Fri, 03 Jan 1997 13:30:35 +0000
From: Petros Dourouklakis <petros@redsnapper.net>
Subject: Re: [mSQL] Problems inserting new data

Thomas Hintze wrote:
>
> Hi folks,
>
> finally I found the time to play around with msql (2.0b1) with
> some absolute simple data before I can start doing real serious
> things with it.
> And here is my firt - absolute newbie - question:
>
> What`s wrong with the following commands ? Something missing ?
>
> -->
>
> mSQL > INSERT INTO tab1(name,nachname)
> -> VALUES ('Marx','Maria')
> -> VALUES ('Alexander','Anette')
> -> \g
>

Thats not a valid SQL command....
You cannot have two VALUES (..) in one sql query. If you want to
insert multiple records multiple queries must be issued.

>
> ERROR : parse error at line 3 near ") values"
>
> <--
>
> When I only put in one VALUES line each, no problem.
>
> (System: SparcStation, SunSolaris 2.4)
>
> Thanks for any help
>
> Thomas
>
> --
> *--------------------------------------------------------*
> * Dr. Thomas Hintze | phone:++49 (0)651 47163 *
> * Kurfuerstenstr. 13 | fax:++49 (0)651 201-3809 *
> * D-54295 Trier | e-mail: hintzet@uni-trier.de *
> * Germany | http://www.hintze-online.com/sos *
> *--------------------------------------------------------*
>
> --------------------------------------------------------------------------
> To remove yourself from the Mini SQL mailing list send a message containing
> "unsubscribe" to > "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
> "info msql-list" to majordomo@bunyip.com for info on monthly archives of
> the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!