Executing multiple statements

Executing multiple SQL statements

Observe the table students. Let’s say we want to add multiple rows of records to it. Let’s see if multiple INSERT statements can work together.

We get a syntax error. That’s because when we execute a single statement it works fine. But when we execute multiple statements, we need a separator between each of them. In SQL, a semicolon (;) serves that purpose. Run the set of statements below:

In SQL, ideally each statement/query should be followed by a semicolon. But we can do without it in a single statement/query. But it becomes important when dealing with multiple statements.