1. CREATE DATABASE: Creates a new database.
Example: CREATE DATABASE my_database;

2. DROP DATABASE: Removes a database.
Example: DROP DATABASE my_database;

3. CREATE TABLE: Creates a new table.
Example: CREATE TABLE my_table (id INT, name VARCHAR(255));

4. ALTER TABLE: Modifies an existing table.
Example: ALTER TABLE my_table ADD COLUMN age INT;

5. SELECT: Retrieves data from a table.
Example: SELECT * FROM my_table;

6. INSERT: Adds data to a table.
Example: INSERT INTO my_table (id, name) VALUES (1, ‘John’);

7. UPDATE: Modifies existing data in a table.
Example: UPDATE my_table SET name = ‘Jane’ WHERE id = 1;

8. DELETE: Removes data from a table.
Example: DELETE FROM my_table WHERE id = 1;

Leave a Reply

Your email address will not be published. Required fields are marked *