SQL Commands that deal with the manipulation of data. - INSERT - UPDATE - DELETE

snippet.sql

-- insert single entry into table
INSERT INTO users (first_name, last_name, email)
VALUES ('John', 'Smith', 'johnsmith@gmail.com');

-- insert multiple entries
INSERT INTO users (first_name, last_name, email)
VALUES ('John', 'Smith', 'johnsmith@gmail.com'), 
('John', 'Doe', 'johndoe@gmail.com');

-- update
UPDATE users
SET email = 'newemail@gmail.com'
WHERE id = 1;

-- delete
DELETE FROM users WHERE id = 1;