Sql query to populate all rows for columns listed below

Can any one pl help me with the sql query to update the columns in all rows for
facility, warehouse and expiry?

Because without these the drugs i saved in inventory dont show up in the reports >> inventory >> list

i used this command

it updated just the three drugs but the rest of the drugs are still not listing in the database.

whereare the other drugs stored in the database?

edited the last post.