Does an SQL query step over a failed constraint or does it fail out completely?

Hi!

So, let’s say I’m inserting a row like this:

INSERT INTO mytable
VALUES (13, “Martin”, “Passenger”)

INSERT INTO mytable
VALUES (more stuff here…)

INSERT INTO mytable
VALUES (more stuff here…);

But the constraint for the data associated with “Martin” has been previously declared to be UNIQUE, and “Martin” is not unique. My question is, will the second and third INSERT INTO clauses work, (assuming that they’re correctly formed and within constraints), or will the interpreter crash out of the query at the first INSERT INTO clause and not even try to do anything with the subsequent clauses?

Thanks!

  • Mark