Mysql Transaction innoDB

Question

I need help making transactions on mysql, i'm doing this but it doesn't work:

START TRANSACTION;
INSERT INTO TipoPedido ('TipoPedi') VALUES ('3');
INSERT INTO TipoPedido ('TipoPedi') VALUES ( '4');
ROLLBACK;

Answer 1

What do you want to do exactly?
What is that table you have?
How do you want your result to look like?

Answer 2

I want to do 3 querry, but if one fail, i want to cancel the other 2

Answer 3

So you want to insert 3 records.
What do you mean by if one fail?

Answer 4

If querry fail because is receiving a duplicate entry
The 3 querry are from different tables that are related, i want to make a rollback if one fails

Answer 5

The Rollback; should work in that case but still I cannot understand your question properly.

Answer 6

Rollback is not working whit me