> -Original Message-
> From: Gary Aitken [mailto:my...@dreamchaser.org]
> Sent: Thursday, June 14, 2012 2:58 PM
>
> I can get the table loaded by specifying REPLACE INTO TABLE, but that
still
> leaves me with not knowing where the duplicate records are.
To find duplicate entries
select d
On 2012-06-14, Gary Aitken wrote:
>
> So... I wanted to read the data line at a time and use a plain INSERT
> statement. That way I could check for duplicate keys and discover where the
> duplicate records are. However, I can't find a way to read input from the
> console or a file. What am
Thanks, Shawn; I knew there was a better way to go about that.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 6/14/2012 5:57 PM, Gary Aitken wrote:
Hi all,
I've looked high and low for what I hope is a trivial answer.
I was trying to load a table using LOAD DATA INFILE. Unfortunately, it craps
out because there are some duplicate primary keys. Not surprising as the
source did not enforce uniquen
- Original Message -
> From: "Gary Aitken"
>
> surprising as the source did not enforce uniqueness. My problem is
> the load data simply dies without indicating which line of the input
> file was in error; the error message refers to line 3, which is not
> even the SQL statement for the
Did you try using "IGNORE" keyword while using the LOAD DATAFILE command.
This will ignore duplicate rows from getting inserted and proceed further.
On Fri, Jun 15, 2012 at 11:05 AM, Keith Keller <
kkel...@wombat.san-francisco.ca.us> wrote:
> On 2012-06-14, Gary Aitken wrote:
> >
> > So... I wa
On 2012-06-14, Gary Aitken wrote:
>
> So... I wanted to read the data line at a time and use a plain INSERT
> statement. That way I could check for duplicate keys and discover where the
> duplicate records are. However, I can't find a way to read input from the
> console or a file. What am
Hi all,
I've looked high and low for what I hope is a trivial answer.
I was trying to load a table using LOAD DATA INFILE. Unfortunately, it craps
out because there are some duplicate primary keys. Not surprising as the
source did not enforce uniqueness. My problem is the load data simply di
