pymysql 설치 및 사용

pymysql 설치

pip install PyMySQL

예)

import pymysql
db = pymysql.connect(host='test.synology.me', port=3307, user='testid', passwd='testpw', db='testdb', charset='utf8')
try:
    with db.cursor() as cursor:
        sql = '''
            CREATE TABLE TEST (
                   id INT UNSIGNED NOT NULL AUTO_INCREMENT,
                   name VARCHAR(20) NOT NULL,
                   model_num VARCHAR(10) NOT NULL,
                   model_type VARCHAR(10) NOT NULL,
                   PRIMARY KEY(id)
            );
        '''
        cursor.execute(sql)
        db.commit()
finally:
    db.close()