Not the answer you need?
Register and ask your own question!

MySQL Mixed Replication uses different method for same query

pparkhillpparkhill EntrantInactive User Role Beginner
mysql>select*from table_in_question;| id | parent_id |key| array_name | value | time | ip | remark | p_id |
| id | parent_id |key| array_name | value | time | ip | remark | p_id |
|2128363|0| fname | o | Sue |2015-03-0208:47:48|0.0.0.0||166817|
|2128365|2128363| lname | o | Susanson |2015-03-0208:47:48|||166817|
|2128367|2128363| address | o |123 Main |2015-03-0208:47:48|||166817|
|2128373|2128363| city | o | Nowhere |2015-03-0208:47:48|||166817|
|2128379|2128363| state | o | LA |2015-03-0208:47:48|||166817|
|2128385|2128363| postcode | o |11111|2015-03-0208:47:48|||166817|
|2128389|0| fname | o | Amy |2015-03-0208:47:58|2.2.2.2||0|
|2128391|2128363| telephone | o |(800)555-1212|2015-03-0208:47:48|||166817|
|2128397|2128363| email_address | o | [email protected] |2015-03-0208:47:48|||166817|
|2128403|2128363| click | o |369490878|2015-03-0208:47:48|||166817|
|2128409|2128363| country | o |223|2015-03-0208:47:48|||166817|
|2128415|2128363| product | c |7|2015-03-0208:47:48|||166817|
|2128421|2128363| g_id | c |1|2015-03-0208:47:48|||166817|
|2128427|2128363| c_id | c |141|2015-03-0208:47:48|||166817|



Last SQL error: Error 'Duplicate entry '2128391' for key 'PRIMARY''on query.Defaultdatabase:'XXX'. Query:'INSERT INTO table_in_question (key,value,array_name,parent_id) VALUES ('lname','Amyson','o',2128389), ('address','444 Main','o',2128389), ('city','Nowhere','o',2128389), ('state','NH','o',2128389), ('postcode','11111','o',2128389), ('telephone','800555-1212','o',2128389), ('email_address','[email protected]','o',2128389), ('country','223','o',2128389), ('product','7','c',2128389), ('g_id','1','c',2128389), ('c_id','141','c',2128389)'
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.