CREATE VIEW order_view AS SELECT o.id, c.name, o.orderdate, o.quantity FROM orders o, catalog c where o.catalogid = c.id order by id desc; ...
mydb=mysql.connector.connect(host="localhost", user="root", password="Rakesh@8280") ...