~/ learn/ comp-378/ cards/ Modifying Data: INSERT / UPDATE / DELETE
1 of 4

Insert a new department (id 6, name Nursing, building HSC, budget 900000) using the full-row VALUES form. (Type-mode: an INSERT has no result set.)

Insert a new department (id 6, name Nursing, building HSC, budget 900000) using the full-row VALUES form. (Type-mode: an INSERT has no result set.)

Answer

INSERT INTO departments VALUES (6, 'Nursing', 'HSC', 900000);

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/951cf001-9d51-405b-8d8b-a5edb3b164e3/flashcard utf-8 LF