How To update info already in a table and Delete a row(s) from a table. | Eklavya Online

How To update info already in a table and Delete a row(s) from a table.

mysql> UPDATE [table name] SET Select_priv = ‘Y’,Insert_priv = ‘Y’,Update_priv = ‘Y’ where [field name] = ‘user’;

mysql> DELETE from [table name] where [field name] = ‘whatever’;