Static column

Static columns are similar to other columns as far as data insertion is concerned.

Prerequisites

Keyspace exists
Table exists
static column exists

This example shows a static column called flag set to a value of 1:

INSERT INTO cycling.country_flag (
  country, cyclist_name, flag
) VALUES (
  'Belgium', 'Jacques', 1
);

INSERT INTO cycling.country_flag (
  country, cyclist_name
) VALUES (
  'Belgium', 'Andre'
);

INSERT INTO cycling.country_flag (
  country, cyclist_name, flag
) VALUES (
  'France', 'Andre', 2
);

INSERT INTO cycling.country_flag (
  country, cyclist_name, flag
) VALUES (
  'France', 'George', 3
);

Static column

Prerequisites

Was this helpful?

Give Feedback