Please I need summary notes on query commands and their format, like how they're supposed to be written in the computer.

Query commands are instructions used to interact with databases, allowing you to retrieve, add, modify, or delete data. These commands are typically written in a language like SQL (Structured Query Language). Here are some common ones and their basic formats:

• SELECT: Used to retrieve specific data from one or more tables. SELECT column1, column2 FROM table_name WHERE condition; The WHERE clause is optional and filters the rows based on a specified condition.

• INSERT: Used to add new rows of data into a table. INSERT INTO table_name (column1, column2) VALUES (value1, value2); You specify the columns you want to populate and their corresponding values.

• UPDATE: Used to modify existing data in one or more rows of a table. UPDATE table_name SET column1 = new_value1, column2 = new_value2 WHERE condition; The WHERE clause is crucial to specify which rows to update; without it, all rows would be updated.

• DELETE: Used to remove one or more rows from a table. DELETE FROM table_name WHERE condition; Similar to UPDATE, the WHERE clause is essential to specify which rows to delete; without it, all rows would be deleted.