파이썬이랑 DB연동하기 23.04.21
import pymysql #변수선언# con,cur=None,None data1,data2,data3="","","" sql='' con = pymysql.connect( host="127.0.0.1", user="root", port=3306, password="1234", db="shopdb", charset='utf8') cur = con.cursor() while True : data1 = input("memberID => ") if data1 == '': break data2 = input("memberName => ") data3 = input("memberAddress => ") sql = "INSERT INTO memberTbl VALUES ('"+data1+"','"+data2+"','..
2023. 4. 21.
