What is CRUD?

CRUD stands for Create, Read, Update, and Delete. It represents the basic operations that can be performed on data in a database.

Examples in SQL:

1. Create:
Adding new records to a table.

    INSERT INTO students (id, name, age)
    VALUES (1, 'John Doe', 20);
    
    

2. Read:
Retrieving data from a table.

    SELECT * FROM students;
    
    

3. Update:

Modifying existing records.

    UPDATE students
    SET age = 21
    WHERE id = 1;
    
    

4. Delete:

Removing records.

DELETE FROM students
WHERE id = 1;