Replicate_Do_DB double entries

2007-07-31 Thread Thomas Spahni
Hi, I have a slave (version 5.0.26) replicating from master (version 4.1.13). The slave's /etc/my.cnf contains the following (just once!): # what we should replicate replicate-do-db = bge replicate-do-db = blog replicate-do-db = lawlist replicate-do-db = library replicate-do-db = mandate replic

Re: Double entries

2003-08-16 Thread Andy Jackman
Trevor, Why not try simplify it to 2 fields and remove most of the validation code? If that works, then you can binary add/delete code until it fails. BTW 'Red' I guess only works on certain mail clients, but not mine, so sorry if I missed something obvious. Regards, Andy. Trevor Morrison wrote:

Double entries

2003-08-16 Thread Trevor Morrison
Hi, I am running the latest MySql on a windows 200 machine. I also use the control center gui to do all my work with. I have a Perl program that parses online order data and then using Perl's DBI I write this data to the database. Now, It all works fine except that each order and orders items

SQL issue: avoid double entries, but note the attempt!

2002-01-16 Thread Spiros Alexiou
understand a UNIQUE INDEX will just filter out the double entries. What I really want to say is: IF INDEX(field1,field2,field3,...,fieldN) is seen, then do not insert this record, but in the existing record, UPDATe field N+1 to whatever it is plus the string ",field0" Example: fiel