keyspace-cycling-alt
CONSISTENCY ALL;
SELECT * FROM cycling_alt.cyclist_name WHERE id = 1;
SELECT * FROM cycling_alt.cyclist_name WHERE id = 1;
CONSISTENCY QUORUM;
SELECT * FROM cycling_alt.cyclist_name WHERE id = 1;
INSERT INTO cycling_alt.cyclist_name (
id, lastname, firstname
) VALUES (
1, 'HOSKINS', 'Melissa'
);
CREATE KEYSPACE IF NOT EXISTS cycling_alt
WITH REPLICATION = {
'class': 'SimpleStrategy',
'replication_factor': 3
};
DESCRIBE KEYSPACE cycling_alt;
DROP KEYSPACE IF EXISTS cycling_alt;
USE cycling_alt;
CREATE TABLE IF NOT EXISTS cycling_alt.cyclist_name (
id int PRIMARY KEY,
lastname text,
firstname text
);
TRACING OFF;
CONSISTENCY;
TRACING ON;
CONSISTENCY;