SQL INSERT
The INSERT command is used to add data to a table.
PostgreSQL, MySQL, and SQL Server
Oracle
insert into tenant (id, name) values
(3, 'Jose'),
(4, 'Terrell');
tenant table before
| id | name |
|---|---|
| 1 | Albert |
| 2 | Marie |
tenant table after
| id | name |
|---|---|
| 1 | Albert |
| 2 | Marie |
| 3 | Jose |
| 4 | Terrell |