Answers for "mysql update a column multiple rows"

mysql update multiple columns

UPDATE [LOW_PRIORITY] [IGNORE] table_name
SET
column_name1 = expr1,
column_name2 = expr2,
…
[WHERE condition];

Posted by: Guest on December-06-2021

mysql update one table from another table multiple columns

update  tabe2 set subject_id = (SELECT GROUP_CONCAT(sub_id SEPARATOR ', ') as sub_id FROM tabe1)

Posted by: Guest on April-05-2021

Code answers related to "mysql update a column multiple rows"