버미다

import pymysqlconn, cur = None,Nonedata1, 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 생성whi..

pymysql 2025. 4. 14. 17:55

import pymysqlconn, cur = None,Nonedata1, 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 )""")while(True): data1= input("사용자 id ===>"..

pymysql 2025. 4. 14. 17:30

import pymysqlconn, cur = None,Nonedata1, 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    )""")while(True):    data1= input("사용자 id ===>"..

pymysql 2025. 4. 13. 21:35