echo "deb http://www.apache.org/dist/cassandra/debian 311x main" | sudo tee -a /etc/apt/sources.list.d/cassandra.sources.list;
curl https://www.apache.org/dist/cassandra/KEYS | sudo apt-key add -;
sudo apt-get update;
sudo apt-get install cassandra;
// start
sudo service cassandra start
//check
cqlsh
如果用docker 輸入 docker ps 然後複製docker id 之後輸入 docker exec -it <docker ID> /bin/bash
cqlsh
1.新增DB
CREATE KEYSPACE tutorialspoint
WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 3};
2.使用DB
USE tutorialspoint;
3.新增Table
CREATE TABLE emp(
emp_id int PRIMARY KEY,
emp_name text,
emp_city text,
emp_sal varint,
emp_phone varint
);
4.確認Table
select * from emp;
5.新增資料
CREATE TABLE users(
user_id int PRIMARY KEY,
user_account text,
user_password text,
);
INSERT INTO users (user_id, user_account, user_password) VALUES(1,'test123', '12345');
