Hi guys, mysql noob here. :)
So here's my problem.
I have 2 tables, Order(order_id,product_id) and Product(product_id,product_name). For one order, I can have many products. So my question is how can I auto increment order_id? When I insert multiple products in the order table, it generates an order_id for each of the products. I want to have the same order_id for all the products that are inserted and then auto increment it for the next order.
I tried hardcoding it in php but is there anyway to do this in mysql?
Thanks in advance ^^