From: Warren Young
Date: June 8 2005 12:00pm
Subject: Re: Query Problems
List-Archive: http://lists.mysql.com/plusplus/4489
Message-Id: <42A6DDD4.7090503@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
John Heinig wrote:
>
> 1, 5, // explained in the user manual
Are you sure that these are the right numbers?
> writeQuery.replace(updatedRow);
You know that a replace query can either insert data, or replace it,
depending on your indexes, right? Have you checked that you aren't
simply replacing an existing row with the same key(s)?
> VALUES (33281,'bot',2,'Triple.Agente.CVCD.DVDrip.[www.TodoCVCD.com].mpg','http://tracker.prq.to/announce','5f4f6da7e3bad30bad2ccb7f51629a8d5abb41d1','http://thepiratebay.org/download.php/3316054/Triple.Agente.CVCD.DVDrip.%5Bwww.TodoCVCD.com%5D1.torrent',1,0,'Unknown',817402172,'2005-05-14','single',1,'','','no',1,'2005-05-14',6)
You said you "typed" the query into another tool, but did you actually
cut and paste this exact query, or did you type something else?