値の更新

UPDATE tablename set column1=value1 where ...

update users set superuser=1 where username='gaku';

重複を取り除く

select distinct userid from users

delete from TABLENAME where ...