My SQL: How to INSERT rows into a TABLE
, mysql EXAMPLE 1 INSERT INTO employees VALUES (1, Eugene, Krabs, 20230102 ); SELECT FROM employees; EXAMPLE 2 INSERT INTO employees VALUES (2, Squidward, Tentacles, 20230103 ), (3, Spongebob, Squarepants, 20230104 ), (4, Patrick, Star, 20230105 ), (5, Sandy, Cheeks, 20230106 ); SELECT FROM employees; EXAMPLE 3 INSERT INTO employees (employeeid, firstname, lastname) VALUES (6, Sheldon, Plankton ); SELECT FROM employees;
|