MySQL Query Editor | vrsofttech

Click 'Execute Query' to execute query.

Tablenames

campaign +
categories +
- category_id
- category_name
customers +
- customer_id
- customer_no
- customer_name
- contact
- email
order_details +
- details_id
- order_no
- product_id
- price
- qty
- total
orders +
- order_id
- order_no
- order_date
- customer_id
- status
products +
- product_id
- product_name
- product_code
- price
- unit
- category_id
report +
- order_no
- QTY
- TOTAL