CODEWITHSUNDEEP
sql
Ori Seri
Ori Seri

Reputation: 967

Insert multiple values and Insert value in parallel

I have a question about SQL in parallel queries. For example, suppose that I have this query:

INSERT INTO tblExample (num) VALUES (1), (2)

And this query:

INSERT INTO tblExample (num) VALUES (3)

The final table should looked like this:

num
---
1
2
3

But I wonder if there is an option that those two queries will run in parallel and the final table will be looked like this:

num
---
1
3
2

Someone know the answer?

Thanks in advance!

Upvotes: 1

Views: 185

Answers (2)

Brendan Long
Brendan Long

Reputation: 54262

How your table "looks" depends on how you asked for it (in the SELECT statement). Without an ORDER BY clause, the order of your table is undefined:

ORDER BY is the only way to sort the rows in the result set. Without this clause, the relational database system may return the rows in any order. If an ordering is required, the ORDER BY must be provided in the SELECT statement sent by the application.

For example:

SELECT num FROM tblExample ORDER BY num ASC

1

2

3

SELECT num FROM tblExample ORDER BY num DESC

3

2

1

If you want to order your columns manually, you can add a new column and sort on it:

+-----+-------+
| num | order |
+-----+-------+
| 1   | 1     |
| 2   | 3     |
| 3   | 2     |
+-----+-------+

SELECT num FROM tblExample ORDER BY order ASC

1

3

2

Upvotes: 1

Ghost
Ghost

Reputation: 2226

There is no order in sql. You can sort your queries by adding an ORDER BY clause

SELECT * FROM tblExample ORDER BY num

Or you could add a timestamp column to the table and order by that.

Upvotes: 1

Related Questions