How to use insert, update, delete query in sql at same time?

Question

Just stuck up, how to use multiple query in single form to execute different query.

eg:

enter image description here Like in image, Table 1 has records.

what i am doing is:

extract first 3 record from table 1 and show in a form (frontend) and when this process is gone..

i need at same time , this happens without refresh and without user data or any frontend disturbance.

Once this data view to user:

i need:

same time, those 3 records get copy to table 2 from table 1. like Roll_no and Name.

Then, remove those 3 records from table 1.

i am doing this to prevent duplicate data and something.

so any code will be helpful.

Your question is very unclear. Are you asking how to execute various statements in a single transaction ? — Deepak Bala
– Deepak Bala, Commented Apr 12, 2013 at 8:14
@devilcrab you don't need to speak perfect English to get answers on stackoverflow I truly am not sure I understand what you are trying to do. I just hope I got it right in my answer — Ivaylo Strandjev
– Ivaylo Strandjev, Commented Apr 12, 2013 at 8:24

Ivaylo Strandjev · Accepted Answer · 2013-04-12 08:22:37Z

2

Your question is quite unclear, but it seems you are concerned about data integrity performing multiple queries. What you need is to use transaction to group a set of commands toghether. This way either all commands will succeed or your database will not be affected by any of them.

answered Apr 12, 2013 at 8:22

Ivaylo Strandjev

71.4k18 gold badges130 silver badges183 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ivaylo Strandjev Over a year ago

@devilcrab that would depend on the database you use and the way you use it. I strongly recommend you research the topic as performing transactions is a very important part of databases.

devilcrab Over a year ago

hmm i am using MySQL, and PHP. and all 3 table are in same database.

Ivaylo Strandjev Over a year ago

Then I guess this is the link you need. I don't think I can explain it in few sentences and as the matter is well documented, I believe it is better for you to read from the source.

devilcrab Over a year ago

Thanks a lot ! now i will get over it :)

Collectives™ on Stack Overflow

How to use insert, update, delete query in sql at same time?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related