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