Geek asks and answers

Make 7 SQL queries like this in one query, is this possible?

I have 7 SQL Query to do this task:

1. UPDATE Customer SET CustomerService = 'perta' WHERE FirstName = 'john';
2. UPDATE Customer SET Flag = 1 WHERE OrderNum BETWEEN 2 AND 29;
3. UPDATE Customer SET PurchaseNum = PurchaseNum + 60 WHERE OrderNum BETWEEN 2 AND 29;
4. UPDATE Customer SET OrderNum = OrderNum + 60 WHERE OrderNum BETWEEN 2 AND 29;
5. UPDATE Customer SET PurchaseNum = PurchaseNum - 28 WHERE (PurchaseNum > 29 AND PurchaseNum <= 89) AND (Flag <> 1);
6. UPDATE Customer SET OrderNum = OrderNum - 28 WHERE (OrderNum > 29 AND OrderNum <= 89) AND (Flag <> 1);
7. UPDATE Customer SET Flag = 0 WHERE OrderNum BETWEEN 62 AND 89;

Is it possible to "compress" these SQL queries into 1 query?

because I’m afraid that the user will cancel the process by pressing the ESC button (after he presses the SUBMIT button), this sequence will be split in the middle, and my table will also be messy.

+3
source share
1 answer

If you use MySQL, you see this link, it shows you how to implement the transaction in MySQL.

http://dev.mysql.com/doc/refman/5.5/en/commit.html

A transaction helps us in many scenarios, and you are processing one of them where you want to update several database tables.

+1
source

More articles:


All Articles