SQL Alchemy updating and deleting data

Delete just one

Report a typo

You are working on a table named Dog. This table has the following fields: id, name, breed, age.

After filling it, you end up with the following result:

Dog datatable

Now, you want to delete the first row and write the following piece of code:

query = session.query(Dog)
query.filter(Dog.name == "Max").delete()

session.commit()

What will happen to the rows in this table?

Select one option from the list

No rows will be deleted

Only the first row will be deleted

The code will throw an exception

All rows that contain the name Max will be deleted

___

Create a free account to access the full topic