Tak jak w tytule.
Kod
mysql> describe user;
+--------------+-------------------+------+---------+------------+-----------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------------+------+---------+------------+-----------------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(180) | NO | UNI | NULL | u |y
| roles | json | NO | | NULL | |
| password | varchar(255) | NO | | NULL | |
+--------------+-------------------+------+--------+-------------+----------------------+
mysql> select * from user;
+----+--------------------------+--------+---------------------------------------------------------------------------------------------------+
| id | email | roles | password |
+----+--------------------------+--------+---------------------------------------------------------------------------------------------------+
| 1 | email@gmail.com | [] |
+--------------+-------------------+------+---------+------------+-----------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------------+------+---------+------------+-----------------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(180) | NO | UNI | NULL | u |y
| roles | json | NO | | NULL | |
| password | varchar(255) | NO | | NULL | |
+--------------+-------------------+------+--------+-------------+----------------------+
mysql> select * from user;
+----+--------------------------+--------+---------------------------------------------------------------------------------------------------+
| id | email | roles | password |
+----+--------------------------+--------+---------------------------------------------------------------------------------------------------+
| 1 | email@gmail.com | [] |
Chcę żeby użytkownik o id=1 miał ROLE_ADMIN.
Jak zrobić UPDATE w MySQL, nie w PHP, żeby nadać mu ROLE_ADMIN ?