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’;

To update information already in a MySQL table, you can use the UPDATE statement. Here’s the syntax:

sql

UPDATE table_name

SET column1 = value1, column2 = value2, ...

WHERE condition;

This will update the values in the specified columns for the rows that meet the specified condition.

To delete row(s) from a MySQL table, you can use the DELETE statement. Here’s the syntax:

sql

DELETE FROM table_name

WHERE condition;

This will delete the rows that meet the specified condition from the table. If you omit the WHERE clause, it will delete all rows from the table.