Cassandra : Gestion de données (INSERT et SELECT)

CREATE KEYSPACE UTC WITH REPLICATION = {'class' : 'SimpleStrategy','replication_factor' : 1};

USE UTC;

CREATE TABLE UTCeen (

    id uuid, 

    nom varchar,

    prenom varchar, 

    age int,

    PRIMARY KEY (id)

);

CREATE KEYSPACE UTC WITH REPLICATION = {'class' : 'SimpleStrategy','replication_factor' : 1};
USE UTC;
CREATE TABLE UTCeen (
    id uuid, 
    nom varchar,
    prenom varchar, 
    age int,
    PRIMARY KEY (id)
);

INSERT INTO UTCeen (id, nom, prenom, age) VALUES(uuid(), 'DEBORD','Guy',20);

INSERT INTO UTCeen (id, nom, prenom, age) VALUES(uuid(), 'FISHER','Bobby',21);

SELECT * FROM UTCeen;

INSERT INTO UTCeen (id, nom, prenom, age) VALUES(uuid(), 'DEBORD','Guy',20);
INSERT INTO UTCeen (id, nom, prenom, age) VALUES(uuid(), 'FISHER','Bobby',21);

SELECT * FROM UTCeen;