pymysql CRUD 기본틀

import pymysql

conn, cur = None,None

data1, data2 , data3, data4 = "","","",""

sql = ""

#메인코드

conn = pymysql.connect(

    host="127.0.0.1",

    user="root",

    passwd="비밀번호",

    db="solodb",

    charset="utf8")

cur=conn.cursor()

# 스카마 생성성

cur.execute("""

    CREATE TABLE IF NOT EXISTS userTable (

        id CHAR(4),

        userName CHAR(15),

        email CHAR(20),

        birthYear INT

    )

""")

# emtity 생성

while(True):

    data1= input("사용자 id ===>")

    if data1 =="":

        break

    data2 = input("사용자 이름=>")

    data3 = input("사용자 이메일==>")

    data4 = input("사용자 출생연도==>")

    sql = "INSERT INTO userTable (id, userName, email, birthYear) VALUES (%s, %s, %s, %s)"

    cur.execute(sql, (data1, data2, data3, int(data4)))

    conn.commit()

# 조회기능

cur.execute("SELECT * FROM userTable")

rows = cur.fetchall()

for row in rows:

    print(row)

# update

# sql = "UPDATE userTable SET userName = %s, email = %s WHERE id = %s"

# cur.execute(sql, ('김철수', 'chulsoo@test.com', 'A001'))

# conn.commit()

# #delete(삭제제)

# sql = "DELETE FROM userTable WHERE id = %s"

# cur.execute(sql, ('A001',))

# conn.commit()

conn.close()