how to make table of sale that sale for then one item in one transaction mysql

11 Views Asked by At

Is there a way to make a column that can have multiple value of id from one table. I want to create a transaction table where user can buy multiple items in one transaction receipt. Iam using MySQL

this is how my current table are

tbl_transaction

id_transaction int auto_increment
id_customer int
product (i dont know the type?)
total_transaction varchar(20)

tbl_product

id_product int auto_increment
product_name varchar(40)
price varchar(20)

so when a customer choose one or more item the id_product can be save in product from table tbl_transaction

0

There are 0 best solutions below