load data

2002-07-29 Thread Natividad Castro
Hi to all, I changed Linux from version 7.2 to 7.3 and now when I try to load data using LOAD DATA LOCAL INFILE I got the following error: The used command is not allowed with this MySQL version. I enable --local-infile=1 But I'm still getting the same error. Any help, is greatly appreciate it T

queries and functions

2002-03-18 Thread Natividad Castro
Hi to all, does mysql have a type of libraries where you can keep queries or functions. For example if I need to run a query everyday, but I don't want to type the same query everytime I need it. How can I store that query in one place and call it every time I need it? Is this possible?? Thanks

RE: Deleting duplicate records

2002-03-05 Thread Natividad Castro
DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 4:32 PM To: Natividad Castro; [EMAIL PROTECTED] Subject: RE: Deleting duplicate records At 16:29 -0500 3/4/02, Natividad Castro wrote: >Thank you very much!! that was very helpful. By the way, is there any other >way to get

RE: Deleting duplicate records

2002-03-04 Thread Natividad Castro
Thank you very much!! that was very helpful. By the way, is there any other way to get rid of duplicate records from a text file? Thanks again Nato -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 3:00 PM To: Natividad Castro Cc: [EMAIL

Deleting duplicate records

2002-03-04 Thread Natividad Castro
Hi to all, I'm new using mysql. I'm trying to load data from a text file to one of my table. This text file contains duplicate records. My question is how do you tell mysql to delete duplicate records and load just the ones that are not duplicate? I already tried the REPLACE and IGNORE key words b