[MySQL] insert fra fil

Article View: dk.edb.database

Article #15098

#15098

From: Jesper Krogh
Date: Wed, 27 Jun 2001 15:01

24 lines
1697 bytes

Hej:-)

Jeg har en fil indeholdende records til en tabel.

Prolemet er at filen indeholder flere felter end de som skal bruges i
tabellen. Kan det lade sig g�re at inds�tte dem i tabellen direkte eller
skal jeg omformattere min datafil (Perljob:-))??

I nedenstaaende er kollonen color ikke defineret i "mytable" og skal
derfor ikke inds�ttes
 
 insert into mytable
 (initials, name, color, phone1, phone2, phone3, phone4)
 values
 ("moly", "red", "Mogens Lykketoft", "99 11 21 12", "88 11 21 12", "77 11
21 12", "66 11 21 12"),
 ("fros", "blue", "Frode S�rensen", "99 12 31 23", "88 12 31 23", "77 12
31 23","66 12 31 23")
--------

P� forh�nd tak!!

Best regards
 Jesper Krogh

Technical Details

Message-ID: <Pine.LNX.4.21.0106271656330.1884-100000@krogh.stofanet.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!krogh.stofanet.dk!krogh

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,47f25438ae044c29,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-27 08:01:51 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!krogh.stofanet.dk!krogh
From: Jesper Krogh <krogh@mail1.stofanet.dk>
Newsgroups: dk.edb.database
Subject: [MySQL] insert fra fil
Date: Wed, 27 Jun 2001 17:01:20 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 25
Message-ID: <Pine.LNX.4.21.0106271656330.1884-100000@krogh.stofanet.dk>
NNTP-Posting-Host: pc115200.stofanet.dk
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=iso-8859-1
Content-Transfer-Encoding: 8BIT
X-Trace: sunsite.dk 993654064 26546 212.10.51.200 (27 Jun 2001 15:01:04 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Wed, 27 Jun 2001 15:01:04 +0000 (UTC)
X-Authenticated: <anon>@<dk>
X-Sender: krogh@krogh.stofanet.dk