mysql>[COLOR=#00008B]select*[COLOR=#00008B]from table_in_question;| id | parent_id |[COLOR=#00008B]key| array_name | value | time | ip | remark | p_id |
| id | parent_id |[COLOR=#00008B]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 | sue@nowhere.com |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 ‘[COLOR=#00008B]PRIMARY’’[COLOR=#00008B]on query.[COLOR=#00008B]Default[COLOR=#00008B]database:‘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’,‘Amy@nowhere.com’,‘o’,2128389), (‘country’,‘223’,‘o’,2128389), (‘product’,‘7’,‘c’,2128389), (‘g_id’,‘1’,‘c’,2128389), (‘c_id’,‘141’,‘c’,2128389)’