Question

Which MySQL command modifies data records in a table?

a) SELECT
b) SHOW
c) DELETE
d) UPDATE

Answer 1

The MySQL command for modifying data records in a table is the UPDATE command. It is used with the SET clause to change values and the WHERE clause to specify which records to update.

Step-by-step explanation:

The MySQL command that modifies data records in a table is d) UPDATE. The UPDATE command is used to change existing data within a table. For example, if you want to change a user's email address in a users table, you would use the UPDATE command along with the SET clause to specify the new email value. It is important to use the WHERE clause to specify which record(s) should be updated to prevent changing data unintentionally. The command would look something like this: UPDATE users SET email = 'newemail xample.com' WHERE user_id = 1;. The other commands listed serve different purposes: SELECT is used to fetch data from a database, SHOW is used to display information about the database structure, and DELETE is used to remove records from a table.