![]() | 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 |
![选中项:](http://localhost/phpmyadmin/themes/original/img/arrow_ltr.png)
SELECT *
FROM `products_discount_quantity`
LIMIT 0 , 30
FROM `products_discount_quantity`
LIMIT 0 , 30
实际显示的价格为pricie*(1-percent)