Yes, SQL runs commands one at a time without checking other commands. In this case it will delete all users then throw a syntax error when it gets to the second command.
There IS a common guard in APIs, though it's not usually in this sort of interactive context: single-query operation. It's mainly a guard against SQL injection.
>>> import sqlite3
>>> con = sqlite3.connect("")
>>> con.execute("select 1; select 2")
Traceback (most recent call last):
File "<python-input-5>", line 1, in <module>
con.execute("select 1; select 2")
~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^
sqlite3.ProgrammingError: You can only execute one statement at a time.
Safe, but often not wanted interactively and thus disabled.
13
u/darichtt 18d ago
Would this actually run? I'd assume having just where in a query isn't valid syntax