cursor.executemany(sql, data)로 다수의 로우 데이터를 INSERT 할 수 있다. sql : INSERT 쿼리 문을 넣으면 된다. sql = """INSERT INTO TBL_NAME (COL1_NAME, COL2_NAME, COL3_NAME) VALUES(%s,%s,%s)""" data : sql 입력 파라미터들을 tuple로 만들고 list로 감싸주면 된다. data = [(parm1,parm2,parm3),(parm1,parm2,parm3),(parm1,parm2,parm3)....] [ERROR] TypeError: not all arguments converted during string sql문에서 ON DUPLICATE KEY UPDATE 사용시 주의 [잘못된 방식] s..

#10.5.4 MySQLCursor.execute() Method cursor.execute(operation, params=None, multi=False) iterator = cursor.execute(operation, params=None, multi=True) This method executes the given database operation (query or command). The parameters found in the tuple or dictionary params are bound to the variables in the operation. Specify variables using %s or %(name)s parameter style (that is, using format..

def input_sql(data, input_table_name, pk=None): """ data: Input Data DataFrame input_table_name: Table name Str pk: Primary Key Name List """ colnames = list(data.columns) INPUT_NAME = '' for col in colnames: INPUT_NAME = INPUT_NAME + col.upper() +',' INPUT_NAME = INPUT_NAME[:-1] VALUES_INPUT = '' for col in colnames: VALUES_INPUT = VALUES_INPUT +'"%s",' VALUES_INPUT = VALUES_INPUT[:-1] sql = f"..

맥북 - Help 11.30 맥북 프로 도착 VSCODE 설치 Tensor flow 설치 및 업그레이드(https://developer.apple.com/metal/tensorflow-plugin/) 맥 단축키 ( https://support.apple.com/ko-kr/HT201236 ) Opt + com + esc 창 강제 종료 Com + tab + q Brew 설치 12.01 12.02 데스크톱 전환 ^+

pip install jupyter-vscode-server https://pypi.org/project/jupyter-vscode-server/ jupyter-vscode-server A Jupyter extension to launch VS Code pypi.org [Using Docker] ENV CODESERVER_URL="https://github.com/cdr/code-server/releases/download/1.1119-vsc1.33.1/code-server1.1119-vsc1.33.1-linux-x64.tar.gz" CODESERVER="code-server1.1119-vsc1.33.1-linux-x64" RUN wget ${CODESERVER_URL} && tar xvf ${CODES..

import matplotlib matplotlib.use('Agg") import matplotlib.pyplot as plt plt.plot() plt.savefig()...