CQL提供了使用Collection数据类型的功能。使用这些集合类型,您可以在单个变量中存储多个值。
例如:CREATE TABLE data(name text PRIMARY KEY, email list<text>);
插入数据:INSERT INTO data(name, email) VALUES ('ramu',['abc@gmail.com','cba@yahoo.com']);
向列表中添加另一封电子邮件:
UPDATE data SET email = email +['xyz@tutorialspoint.com'] where name = 'ramu';
使用set集合创建表:
CREATE TABLE data2 (name text PRIMARY KEY, phone set<varint>);
INSERT INTO data2(name, phone)VALUES ('rahman',{9848022338,9848022339});
UPDATE data2 SET phone = phone + {9848022330} where name = 'rahman';
Map集合创建表:
CREATE TABLE data3 (name text PRIMARY KEY, address map<timestamp, text>);