update sql

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

UPDATE ims_zhyshop_sun_video SET is_recommend=1 WHERE id=1;

delete sql

DELETE FROM table_name WHERE condition;

按手机号分组（找出重复的手机号）

select phone from ims_zhyshop_sun_user GROUP BY phone HAVING count(phone) >=2