Computer scienceProgramming languagesPythonPython librariesSQL Alchemy

SQL Alchemy updating and deleting data

Filter first

Report a typo

Take a look at this table that contains info on old computers:

Old computer table

You can see that some fields are identical or very similar, which means that your criteria must be very specific, or you may end up selecting the rows you don't want.

You want to update or delete the Sanyo PHC-20. What is the best way to filter this row?

Select one option from the list

query.filter(Computer.country == "Japan")

query.filter(Computer.name == "Sanyo PHC-")

query.filter(Computer.year == "1982")

query.filter(Computer.id == 4)

query.filter(Computer.id == 5)

___

Create a free account to access the full topic