LU07b - SQL-DML: INSERT

Sources

1. W3Schools | INSERT INTO
2. MySQL.COM | INSERT INTO
3. Youtube | INSERT INTO

The INSERT command is used to add new records to a table. When using INSERT, it is essential to specify the table and columns where the data will be added.

Syntax

INSERT INTO table_name (column1, column2, column3) 
VALUES (value1, value2, value3);

Example

INSERT INTO employees (employee_id, first_name, last_name, hire_date, salary) 
VALUES (1, 'John', 'Doe', '2023-09-18', 55000);

Volkan Demir