SQLite Editor

SELECT
	employeeid,
	firstname,
	lastname,
	title,
	email
FROM
	employees;

UPDATE employees
SET lastname = 'Smith'
WHERE
	employeeid = 3;

SELECT
	employeeid,
	firstname,
	lastname,
	title,
	email
FROM
	employees
WHERE
	employeeid = 3;

UPDATE employees
SET city = 'Toronto',
    state = 'ON',
    postalcode = 'M5P 2N7'
WHERE
    employeeid = 4;

SELECT
	employeeid,
	firstname,
	lastname,
	state,
	city,
	PostalCode
FROM
	employees
WHERE
	employeeid = 4;

SELECT
	employeeid,
	firstname,
	lastname,
	email
FROM
	employees;

UPDATE employees
SET email = lower(
	firstname || "." || lastname || "@chinookcorp.com"
)
ORDER BY
	firstname
LIMIT 1;

UPDATE employees
SET email = lower(
	firstname || "." || lastname || "@chinookcorp.com"
);

Dark Mode

Enter a query, then click the execute button or press F9 to run it.