don't insert in table if a error in MYSQL Transaction

Asked Dec 29 '13 at 16:28

Active Dec 29 '13 at 16:44

Viewed 67 times

I have a transaction in mysql which insert data into two tables (it works fine ):

    START TRANSACTION;
    INSERT INTO tbl_chart (acode,adesc)  VALUES (2,'3');
    INSERT INTO tbl_pics  (ID ,adesc) VALUES (1,'1');
    COMMIT ;

But i want that if a error comes then the data should not be inserted in the particular tables . But now when error comes it shows it and also saves the data in table . I do not want this . i want that if error comes then it shows the error and do not save the data in tables . ? how to do it ?

edited Dec 29 '13 at 16:44

Arman

1,434
2
22
42

asked Dec 29 '13 at 16:28

Rehamk

1

Not sure what VB.NET and WPF have to do with this – Steve Dec 29 '13 at 16:30
No man just tell me how to do this in mysql ? – Rehamk Dec 29 '13 at 16:33
1

what error condition are you concerned about? A SQL error? A VB error? A WPF/NET error? You need to be more specific about KIND of errors you are talking about. – Ňɏssa Pøngjǣrdenlarp Dec 29 '13 at 16:42
Don't run the transaction if an error occurs. – Bart Friederichs Dec 29 '13 at 16:46
Plutonix I am concerning about a SQL error . – Rehamk Dec 29 '13 at 17:25
I want that if a sql error happen then the data should not be saved . for example if there is an error in second query then the first also should not be saved and vice versa – Rehamk Dec 29 '13 at 17:26
Check this out: http://stackoverflow.com/questions/9327668/mysql-transaction-rollback-on-failure-in-update – Marty McVry Dec 29 '13 at 18:47

don't insert in table if a error in MYSQL Transaction

0 Answers0