gistfile1.txt

MariaDB [moritz5]> SET NAMES utf8mb4;
Query OK, 0 rows affected (0.00 sec)

MariaDB [moritz5]> update ilbot_lines set line = '🍕' where id = 15168776;
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1

MariaDB [moritz5]> select * from ilbot_lines where id = 15168776;
+----------+--------+-------+------------+------+------+------------+
| id       | day    | nick  | timestamp  | line | spam | in_summary |
+----------+--------+-------+------------+------+------+------------+
| 15168776 | 108737 | jdv79 | 1505483743 | ?    |      |            |
+----------+--------+-------+------------+------+------+------------+
1 row in set (0.00 sec)

MariaDB [moritz5]> update ilbot_lines_mb4 set line = '🍕' where id = 15168772;Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [moritz5]> select * from ilbot_lines_mb4 where id = 15168772;+----------+--------+-------+------------+------+------+------------+
| id       | day    | nick  | timestamp  | line | spam | in_summary |
+----------+--------+-------+------------+------+------+------------+
| 15168772 | 108737 | jdv79 | 1505483743 | 🍕     |      |            |
+----------+--------+-------+------------+------+------+------------+
1 row in set (0.00 sec)

MariaDB [moritz5]>