mysqli_query($CONNECT, "UPDATE `account` SET `balance` = '$balance[1]' WHERE `id` = '$likes'");
mysqli_query($CONNECT, "UPDATE `account` SET `last` = '$last' WHERE `id` = '$likes'");
mysqli_query($CONNECT, "UPDATE `account` SET `last_work` = 'like' WHERE `id` = '$likes'");
mysql -u user -p database < data.sql select exmp.name, sum(exmp.money), sum(exmp_t.money) from exmp
left join exmp as exmp_t on exmp_t.name = exmp.name
where exmp.paymentType = 'Cash' AND exmp_t.paymentType = 'Credit' group by exmp.nameselect name, sum(money) as cash, (select sum(exmp_t.money) from exmp as exmp_t where exmp_t.paymentType = 'Credit' AND exmp_t.name=exmp.name) as credit from exmp where paymentType = 'Cash' group by nameUPDATE table1, table2, ...
SET table1.column1 = expression1,
table2.column2 = expression2,
...
WHERE table1.column = table2.column
AND conditions;