Python에서 MySQLdb을 이용하여 MySQL 연동

• MySQLdb 라이브러리 import

import MySQLdb

 

connection = MySQLdb.connect(
    user = "scrapingman",
    passwd = "",
    host = "localhost",
    db = "scrapingdata",
    charset = "utf8")

 

cursor = connection.cursor()

 

cursor.execute("CREATE TABLE drama_info (id int auto_increment, drama_name varchar(50), channel varchar(10), start_time time, primary key(id))")

 

connection.commit()