By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (
member_id bigint(20) NOT NULL,
server_id bigint(11) NOT NULL,
basket varchar(10000) NOT NULL,
shop varchar(30) NOT NULL,
notes varchar(1000) DEFAULT NULL,
PRIMARY KEY (member_id, shop)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO table_name (member_id, server_id, basket, shop)
VALUES (100, 1, 'X', 'ShopA')
ON DUPLICATE KEY UPDATE basket = CONCAT (basket, 'X');
SELECT * FROM table_name;
| member_id | server_id | basket | shop | notes |
|---|---|---|---|---|
| 100 | 1 | X | ShopA | null |
INSERT INTO table_name (member_id, server_id, basket, shop)
VALUES (100, 1, 'a', 'ShopA')
ON DUPLICATE KEY UPDATE basket = CONCAT (basket, 'a');
SELECT * FROM table_name;
| member_id | server_id | basket | shop | notes |
|---|---|---|---|---|
| 100 | 1 | Xa | ShopA | null |
INSERT INTO table_name (member_id, server_id, basket, shop)
VALUES (100, 1, 'b', 'ShopB')
ON DUPLICATE KEY UPDATE basket = CONCAT (basket, 'b');
SELECT * FROM table_name;
| member_id | server_id | basket | shop | notes |
|---|---|---|---|---|
| 100 | 1 | Xa | ShopA | null |
| 100 | 1 | b | ShopB | null |