Skip to main content
deleted 6 characters in body
Source Link
Tony
  • 101
  • 3

you can use UPDATE like this:

UPDATE `products`
SET `quantity``price` = 200
WHERE ID = 2;

or REPLACE like this:

REPLACE into products (id, quantityprice) values(2, 200);

you can use UPDATE like this:

UPDATE `products`
SET `quantity` = 200
WHERE ID = 2;

or REPLACE like this:

REPLACE into products (id, quantity) values(2, 200);

you can use UPDATE like this:

UPDATE `products`
SET `price` = 200
WHERE ID = 2;

or REPLACE like this:

REPLACE into products (id, price) values(2, 200);
Source Link
Tony
  • 101
  • 3

you can use UPDATE like this:

UPDATE `products`
SET `quantity` = 200
WHERE ID = 2;

or REPLACE like this:

REPLACE into products (id, quantity) values(2, 200);