Cacher is the code snippet organizer for pro developers

-- INSERT
-- DELETE
-- UPDATE
---

-- INSERT
INSERT INTO ATTENDEE (FIRST_NAME, LAST_NAME)
VALUES
('Thomas', 'Nield')
('Sebastian', 'Krug')
('Benjamin', 'Burghardt')
('Falko', 'Schlaffke')

-- insert data from another table
INSERT INTO ATTENDEE (FIRST_NAME, LAST_NAME, PHONE, EMAIL)
SELECT FIRST_NAME, LAST_NAME, PHONE, EMAIL
FROM SOME_OTHER_TABLE


-- DELETE
DELETE FROM ATTENDEE    --> deletes all entries in the table

DELETE FROM ATTENDEE
WHERE PHONE IS NULL
AND EMAIL IS NULL

-- TRUNCATE
TRUNCATE TABLE ATTENDEE     --> not in SQLite but in SQL to delete all data in table

-- DROP TABLE
DROP TABLE My_Unwanted_Table


-- UPDATE
UPDATE ATTENDEE SET EMAIL = UPPER(EMAIL)    --> all emails upper case

UPDATE ATTENDEE SET FIRST_NAME = UPPER(FIRST_NAME), LAST_NAME = UPPER(LAST_NAME) --> update both values

UPDATE ATTENDEE SET VIP = 1 --> update VIP to true if ATTENDEE_ID is either 3 or 4
WHERE ATTENDEE_ID IN (3,4)