​​discount_id​

​​products_id​

​​discount_qty​

​​discount_price​


5

1

101

13.0000


4

1

51

15.0000


3

1

31

17.0000


2

1

11

19.0000


1

1

5

21.0000

SELECT *
FROM `products_discount_quantity`
LIMIT 0 , 30

实际显示的价格为pricie*(1-percent)