- A INSERT INTO
- B UPDATE TABLE
- C ADD ROW
- D MODIFY ROW
Time Taken:
Correct Answer:
Wrong Answer:
Percentage: %
The INSERT INTO statement in MySQL is used to insert new rows into a table. It allows you to specify the table name and the values to be inserted into the respective columns.
The AGGREGATE statement in MySQL is used to perform calculations on data, such as computing sums, averages, counts, and other aggregate functions.
The LIMIT statement in MySQL is used to limit the number of rows returned by a query. It allows you to specify the maximum number of rows to be retrieved.
The WHERE statement in MySQL is used to specify conditions for data retrieval. It allows you to filter rows based on specified criteria.
The INSERT SELECT statement in MySQL is used to insert data into a table by selecting values from another table. It allows you to combine data from different tables during insertion.
The CONCAT statement in MySQL is used to perform string concatenation. It allows you to combine multiple strings or column values into a single string.
The LIKE statement in MySQL is used to perform case-sensitive pattern matching. It allows you to search for patterns within strings with optional wildcard characters.
The UPDATE JOIN statement in MySQL is used to update rows in a table based on values from another table. It allows you to establish a join between the tables to match and update corresponding rows.
The DELETE statement in MySQL is used to delete specific rows from a table based on a condition. It allows you to selectively remove rows that meet the specified criteria.
The SET NULL statement in MySQL is used to update a column with a NULL value. It allows you to set a column's value to NULL, indicating the absence of a value.