Last post Apr 12, 2019 02:28 PM by limno
Apr 12, 2019 01:23 PMfirstname.lastname@example.org|LINK
i want to send these inserts query by once at the same time but when second have the problem and not inserted the first row will be inserted but second row and
third are not inserted because second have the problem but i want also first not inserted if second row have the problem how can i solve that issue
insert into tb value(1,'a',10.2)
insert into tb value(2,'b',10.5)
insert into tb value(3,'c',10.3)
Apr 12, 2019 01:45 PM|scala_1988|LINK
You have to use Stored Procedure for INSERT statement using COMMIT, ROLL BACK. You can get sample examples in google.
Apr 12, 2019 02:28 PM|limno|LINK
You may change your mindset to set operation in relational database.
It does not work the way you are thinking. Check out the term ACID.