Mailing List Archive


Back to the month index Back to the list index
Edgar Matzinger (matzingr@iclab.ce.philips.nl)
Fri, 3 Jan 1997 09:51:21 +0100 (MET) 

From: matzingr@iclab.ce.philips.nl (Edgar Matzinger)
Message-Id: <199701030851.AA099411482@iclab.ce.philips.nl>
Subject: Re: [mSQL] Problems inserting new data
Date: Fri, 3 Jan 1997 09:51:21 +0100 (MET)

>
> 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
>
>
> ERROR : parse error at line 3 near ") values"
>
> <--
>
> When I only put in one VALUES line each, no problem.
>
> (System: SparcStation, SunSolaris 2.4)
>

Hi Thomas,

  using INSERT you can only insert one (name, nachname)-pair
at a time into your database. If you have a lot of data you
have to enter into your database, you might take a look into
msqlimport. This enters the contents of an asciifile into
a table in a database you specify.

HTH, cu l8r, 

-- 
Edgar.

    |\  /| :                                : Addr: Philips Sound & Vision
 /  | \/ | :     Edgar R. Matzinger         :       t.a.v. E.R. Matzinger
/   |    | :                                :       building: SFJ-6.58
\  /|  /\| :                                :       P.O. Box 80002
 \/   /  \ :     Philips Sound & Vision     :       5600 JB Eindhoven
  \  /\  / : Advanced Systems & Appl. Labs. :       The Netherlands
   \/ |\/  : Integrated Circuits Laboratory :Email:
      |    :                                : matzingr@iclab.ce.philips.nl
Disclaimer: Any comments, opinions made are mine, etc ...
--------------------------------------------------------------------------
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!