PostgreSQL

sudo yum install postgresql -y

sudo psql --host=database.endpoint --port=5432 --username=postgres --pas
sword
列出所有資料庫
$ \l
建立新資料庫
$ CREATE DATABASE mydb;
連線資料庫/切換資料庫
$ \c mydb
列出所有 Tables
$ \d
建立 table 範例
CREATE TABLE films (
  code        char(5) CONSTRAINT firstkey PRIMARY KEY,
  title       varchar(40) NOT NULL,
  did integer NOT NULL,
  date_prod   date,
  kind        varchar(10),
  len         interval hour to minute
);
刪除 table
DROP TABLE IF EXISTS table;

Mysql

sudo yum install mysql -y

mysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -p
show databases;
SHOW TABLES;
create database mydb;
drop database mydb;
 
#首先是要指定一個數據庫為當前數據庫，應該用use命令

mysql>use mydb;
mysql> create table mytab (
    -> id INT AUTO_INCREMENT,
    -> name VARCHAR(30),
    -> xpos INT,
    -> ypos INT,
    -> exp INT,
    -> PRIMARY KEY (id) );
describe mytab;

#References

https://docs.aws.amazon.com/zh_tw/AmazonRDS/latest/UserGuide/CHAP_CommonTasks.Connect.html https://docs.aws.amazon.com/zh_tw/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html