there are 2 different queries below. How can I run them at the same time? I mean, these 2 data’s will be into on the same row. For example: https://prnt.sc/rtkytf
x
INSERT INTO data (request_string)
VALUES
('request_string_test1'),
('request_string_test2');
INSERT INTO data (redirect_string)
VALUES
('redirect_string_test1'),
('redirect_string_test2');
Advertisement
Answer
Doesn’t this do what you want?
INSERT INTO data (request_string, redirect_string)
VALUES ('request_string_test1', 'redirect_string_test1'),
('request_string_test2', 'redirect_string_test2');
Otherwise, if you really want to insert four rows:
INSERT INTO data (request_string, redirect_string)
VALUES ('request_string_test1', DEFAULT),
('request_string_test2', DEFAULT),
(DEFAULT, 'redirect_string_test1'),
(DEFAULT, 'redirect_string_test2');
The default value is often NULL
(because no DEFAULT
is specified). If you know that is the case, you can use NULL
instead.