1) 创建Keyspace的CQL语句
CREATE KEYSPACE test with strategy_class = 'SimpleStrategy' and strategy_options:replication_factor=1;
2)创建ColumnFamily的CQL语句
CREATE COLUMNFAMILY users (key varchar PRIMARY KEY,full_name varchar,birth_date int,state varchar);
3)创建索引
CREATE INDEX ON users (birth_date);CREATE INDEX ON users (state);
4)插入数据
INSERT INTO users (key, full_name, birth_date, state) VALUES ('bsanderson', 'Brandon Sanderson', 1975, 'UT');
INSERT INTO users (key, full_name, birth_date, state) VALUES ('prothfuss', 'Patrick Rothfuss', 1973, 'WI');
INSERT INTO users (key, full_name, birth_date, state) VALUES ('htayler', 'Howard Tayler', 1968, 'UT');
5)Select语句
SELECT key, state FROM users;
6)带条件的SELECT语句
条件语句必须注意的事项:
必须有个条件是“等于”操作,并且这个字段是被索引的
SELECT key FROM users WHERE state='UT' AND birth_date > 1970;
7)Update语句
必须用key进行更新
UPDATE users SET full_name='charlie ' WHERE key='bsanderson'
8)DELETE语句
必须用key进行删除
DELETE FROM users WHERE key='bsanderson'DELETE full_name FROM users WHERE key='bsanderson'
9)安全性:
我原以为可能存在CQL注入,我做了些程序进行测试,因为无法同时执行2条语句,所以从根本上杜绝了CQL注入的可能性。
参考: