pip install pymysql
import pymysql
conn = pymysql.connect(
host='DB 아이피 혹은 엔드포인트',
user='admin',
password='비번',
db='DB이름',
charset='utf8')
import pymysql
conn = pymysql.connect(
host='DB주소',
user='admin',
password='비번',
db='DB이름',
charset='utf8')
curs = conn.cursor()
sql = "SELECT * FROM student"
curs.execute(sql)
rows = curs.fetchall()
print(rows)
import pymysql
def lambda_handler(event, context):
conn = pymysql.connect(
host='DB주소',
user='admin',
password='qwer1234',
db='minji',
charset='utf8')
curs = conn.cursor()
sql = "SELECT * FROM student"
curs.execute(sql)
rows = curs.fetchall()
print(rows)
return 0
curs = conn.cursor()
sql = "INSERT INTO student VALUES('bird',10)"
curs.execute(sql)
conn.commit()
sql = "INSERT INTO student VALUES('bird',10)"
("+event["sname"]+","+event["sage"]+")
import pymysql
def lambda_handler(event, context):
conn = pymysql.connect(
host='db.c2utzejdxsyw.ap-northeast-2.rds.amazonaws.com',
user='admin',
password='qwer1234',
db='minji',
charset='utf8')
curs = conn.cursor()
sql = "SELECT * FROM student"
curs.execute(sql)
curs = conn.cursor()
sql = "INSERT INTO student VALUES ('"+event["sname"]+"',"+str(event["sage"])+")"
curs.execute(sql)
conn.commit()
rows = curs.fetchall()
print(rows)
return 0
![[AWS] Lambda와 RDS 연동: 데이터 조회·삽입](/posts/aws-lambda-rds/images/image_1.jpg)