table-popular-count

BEGIN COUNTER BATCH

  UPDATE cycling.popular_count
  SET popularity = popularity + 1
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

  UPDATE cycling.popular_count
  SET popularity = popularity + 125
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

  UPDATE cycling.popular_count
  SET popularity = popularity - 64
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

APPLY BATCH;

SELECT * FROM cycling.popular_count;

CREATE TABLE IF NOT EXISTS cycling.popular_count (
  id UUID PRIMARY KEY,
  popularity counter
);

DESCRIBE TABLE cycling.popular_count;

DROP TABLE IF EXISTS cycling.popular_count;

UPDATE cycling.popular_count SET popularity = popularity + 2
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

table-popular-count

Was this helpful?

Give Feedback