List:General Discussion« Previous MessageNext Message »
From:Bogdan Paduraru Date:September 23 1999 3:30pm
Subject:Re: LOAD DATA
View as plain text  
Yeap, I got it after I send you the mesagge. It worked.
Anyway thanx a lot folks.

----- Original Message -----
From: Martin Ramsch <m.ramsch@stripped>
To: Bogdan Paduraru <bpaduraru@stripped>
Sent: Friday, September 24, 1999 2:29 PM
Subject: Re: LOAD DATA


> Bogdan,
>
> > Yes, I understood your explanation. But the table is like this :
> > name | month | day | hour_in | hour_out | logon_time
> > and so I have to check if all the fields are new. I can't make a Primary
Key
> > on day or something else because I'll lose data.
>
> why not define the primary key to include _all_ fields?  Then only
> identical lines would be rejected, but definitely no loss of data!
>
> Regards,
>   Martin
> --
> Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/
>
> PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
>

Thread
LOAD DATABogdan Paduraru22 Sep
  • Re: LOAD DATAMartin Ramsch23 Sep
    • Re: LOAD DATAPaul DuBois23 Sep
  • Re: LOAD DATABogdan Paduraru24 Sep