SQL INSERT: Examples

Examples
Sample Database

#1

INSERT INTO dependents (
	first_name,
	last_name,
	relationship,
	employee_id
)
VALUES
	(
		'Dustin',
		'Johnson',
		'Child',
		178
	);

#2

SELECT 
    *
FROM
    dependents
WHERE
    employee_id = 178;

#3

INSERT INTO dependents (
	first_name,
	last_name,
	relationship,
	employee_id
)
VALUES
	(
		'Cameron',
		'Bell',
		'Child',
		192
	),
	(
		'Michelle',
		'Bell',
		'Child',
		192
	);

#4

SELECT 
    *
FROM
    dependents
WHERE
    employee_id = 192;

#5

INSERT INTO dependents_archive SELECT
	*
FROM
	dependents;

#6

SELECT
	*
FROM
	dependents_archive;

Table List

countries

SELECT * FROM countries;

departments

SELECT * FROM departments;

dependents

SELECT * FROM dependents;

employees

SELECT * FROM employees;

jobs

SELECT * FROM jobs;

locations

SELECT * FROM locations;

regions

SELECT * FROM regions;

SQL Query

Execute

Clear Beautify Minify

Reload

Result