table-cyclist-id

INSERT INTO cycling.cyclist_id (
  lastname, firstname, age, id
) VALUES (
  'EENKHOORN', 'Pascal', 18, ffdfa2a7-5fc6-49a7-bfdc-3fcdcfdd7156
);

INSERT INTO cycling.cyclist_id (
  lastname, firstname, age, id
) VALUES (
  'WELTEN', 'Bram', 18, 18f471bf-f631-4bc4-a9a2-d6f6cf5ea503
);

INSERT INTO cycling.cyclist_id (
  lastname, firstname, age, id
) VALUES (
  'COSTA', 'Adrien', 17, 15a116fc-b833-4da6-ab9a-4a7775752836
);

DELETE id FROM cycling.cyclist_id
WHERE lastname = 'WELTEN'
  AND firstname = 'Bram'
IF age = 20;

DELETE id FROM cycling.cyclist_id
WHERE lastname = 'JONES'
  AND firstname = 'Bram'
IF EXISTS;

SELECT firstname AS first,lastname AS last FROM cycling.cyclist_id
  WHERE lastname = 'COSTA' AND firstname = 'Adrien';

SELECT * FROM cycling.cyclist_id
WHERE lastname = 'EENKHOORN'
  AND firstname = 'Pascal'
  AND age IN (17, 18);

ALTER TABLE cycling.cyclist_id
WITH CDC = false;

CREATE TABLE IF NOT EXISTS cycling.cyclist_id (
  lastname text,
  firstname text,
  age int,
  id UUID,
  PRIMARY KEY ((lastname, firstname), age)
);

CREATE TABLE IF NOT EXISTS cycling.cyclist_id (
  lastname text,
  firstname text,
  age int,
  id uuid,
  PRIMARY KEY ((lastname, firstname))
);

DESCRIBE TABLE cycling.cyclist_id;

DESCRIBE TABLE cycling.cyclist_id;

DESCRIBE TABLE cycling.cyclist_id;

DROP TABLE IF EXISTS cycling.cyclist_id;

UPDATE cycling.cyclist_id SET id = UUID()
WHERE lastname = 'WELTEN'
  AND firstname = 'Bram'
  AND age = 18
IF EXISTS;

UPDATE cycling.cyclist_id SET id = UUID()
WHERE lastname = 'WELTEN'
  AND firstname = 'Bram'
  AND age = 18
IF id = 18f471bf-f631-4bc4-a9a2-d6f6cf5ea503;

UPDATE cycling.cyclist_id SET id = UUID()
WHERE lastname = 'Smith'
  AND firstname = 'Joe'
  AND age = 22
IF id = NULL;