An old import left extra tables in this database. The shop uses only products. The tables products_old, products_2023 and tmp_import are leftovers. Look before you remove anything.
- How many rows does
products_oldhold? - Remove
tmp_import. - Remove
products_oldandproducts_2023with one statement. Keepproducts. - The team rebuilds the table
restock_alertsoften, and its old rows do not matter. Write one script that removesrestock_alertswhen it exists, then creates it with three columns:product_id(whole number),min_stock(whole number) andemail(text). Run the script two times. Both runs must work.