python 데이터베이스 select, insert 조회 삽입

python으로 mysql 데이터베이스 select, insert 하기

python 데이터베이스 조회 select

import pymysql
conn = pymysql.connect(
	host='127.0.0.1', 
	port=3306, 
	user='username', 
	password='password!!*', 
	db='db-name', 
	charset='utf8' 
) 
try: 
	with conn.cursor() as cursor:
		sql = "select * from table_name"
		cursor.execute(sql)
		result = cursor.fetchall()
finally: 
	conn.close()

python 데이터베이스 삽입 insert

import pymysql
conn = pymysql.connect(
	host='127.0.0.1',
	port=3306,
	user='username',
	password='password!!',
	db='db_name',
	charset='utf8'
)
try:
	with conn.cursor() as curs:
		sql = "insert into table_name( column1, column2,...) values (%s, %s, ...)"
		curs.execute(sql, (arg1, arg2,...)    
		conn.commit()
finally:
	conn.close()