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

Welcome back 👑ApN~Glam👑 — missed you this week. 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. Got more? Send 'em 📸