Jump to content

Убрать или заменить 4 нуля цены после запятой.


В данном примере оставляем 2 нуля после запятой вместо 4

ALTER TABLE  `oc_product` CHANGE  `price`  `price` DECIMAL( 15, 2 ) NOT NULL DEFAULT  '0.0000';
ALTER TABLE  `oc_product_discount` CHANGE  `price`  `price` DECIMAL( 15, 2 ) NOT NULL DEFAULT  '0.0000';
ALTER TABLE  `oc_product_special` CHANGE  `price`  `price` DECIMAL( 15, 2 ) NOT NULL DEFAULT  '0.0000';

 


Comments

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...