#keysapce操作创建、删除、使用:keyspace就相当于数据库。
[default@Keyspace2] use Keyspace1
... ;
Authenticated to keyspace: Keyspace1
[default@Keyspace1] drop keyspace
... Keyspace1;
fa38adf8-3866-33c3-8f3a-786fad17c7e0
[default@unknown] use Keyspace1;
Keyspace 'Keyspace1' not found.
[default@unknown] create keyspace Keyspace1;
7e015fd3-e83b-36a0-9674-7c443495ca6a
[default@unknown] use Keyspace1;
Authenticated to keyspace: Keyspace1
[default@Keyspace1]
创建列族column family
column family 就相当于关系数据库中的表。
- [default@mykeyspace] create column family User;
- 3c077f98-7039-372e-8447-c66c2fb38432
- [default@mykeyspace]
插入数据
- [default@mykeyspace] set User[ascii('zhangsan')][ascii('name')]=ascii('zhangsan');
- Value inserted.
- Elapsed time: 48 msec(s).
- [default@mykeyspace] set User[ascii('zhangsan')][ascii('age')]=ascii('18');
- Value inserted.
- Elapsed time: 6.97 msec(s).
- [default@mykeyspace]
统计数据
- default@mykeyspace] get User[ascii('zhangsan')];
- > (column=616765, value=18, timestamp=1363753306031000)
- > (column=6e616d65, value=zhangsan, timestamp=1363753293734000)
- eturned 2 results.
- lapsed time: 21 msec(s).
- default@mykeyspace]
删除数据
- [default@mykeyspace] del User[ascii('zhangsan')];
- row removed.
- Elapsed time: 12 msec(s).
- [default@mykeyspace] get User[ascii('zhangsan')];
- Returned 0 results.
- Elapsed time: 1.68 msec(s).