SQL

From Torben's Wiki
Revision as of 09:38, 19 January 2021 by Torben (talk | contribs) (Created page with "===Insert multiple rows=== INSERT INTO q_role (role_name, department_id, user_id) VALUES ('ROLE_ADMIN',-30005,-30001), ('ROLE_READ',-30005,-30001)")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Insert multiple rows

INSERT INTO q_role (role_name, department_id, user_id)
VALUES 
('ROLE_ADMIN',-30005,-30001),
('ROLE_READ',-30005,-30001)