AWS_RDS

PostgreSQL

sudo yum install postgresql -ysudo psql --host=database.endpoint --port=5432 --username=postgres --password列出所有资料库$ \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);删除 tableDROP TABLE IF EXISTS table;

Mysql

sudo yum install mysql -ymysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -pshow 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