mirror of
https://github.com/grocy/grocy.git
synced 2025-09-16 17:56:51 +00:00
5 lines
190 B
MySQL
5 lines
190 B
MySQL
|
UPDATE user_settings
|
||
|
|
SET value = '10'
|
||
|
|
WHERE key IN ('stock_decimal_places_amounts', 'stock_decimal_places_prices_input', 'stock_decimal_places_prices_display')
|
||
|
|
AND CAST(value AS INT) > 10;
|