add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
version()
8.0.30
create table t
(id INT Primary Key,
product_id INT,
store_id INT,
inventory_stok float(15.0)
);


insert into t values (622,2364,6,2382980);


UPDATE t SET `inventory_stok` = '2382979' WHERE `id` = 622;

select * from t;


Rows matched: 1  Changed: 1  Warnings: 0
id product_id store_id inventory_stok
622 2364 6 2382980
UPDATE t SET `inventory_stok` = 2382979 WHERE `id` = 622;

select * from t;
Rows matched: 1  Changed: 0  Warnings: 0
id product_id store_id inventory_stok
622 2364 6 2382980
alter table t
modify column inventory_stok int;
Records: 1  Duplicates: 0  Warnings: 0
UPDATE t SET `inventory_stok` = 2382979 WHERE `id` = 622;

select * from t;
Rows matched: 1  Changed: 0  Warnings: 0
id product_id store_id inventory_stok
622 2364 6 2382979