CREATE TABLE log_entries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    timestamp DATETIME,
    log_level VARCHAR(10),
    message TEXT,
    extra_info TEXT
);

import logging
import mysql.connector
from mysql.connector import Error

class MySQLHandler(logging.Handler):
    def __init__(self, host, user, password, database):
        super().__init__()
        self.connection = mysql.connector.connect(
            host=host,
            user=user,
            passwd=password,
            database=database
        )
        self.cursor = self.connection.cursor()

    def emit(self, record):
        log_entry = self.format(record)
        query = "INSERT INTO log_entries (timestamp, log_level, message) VALUES (%s, %s, %s)"
        self.cursor.execute(query, (record.asctime, record.levelname, log_entry))
        self.connection.commit()

logger = logging.getLogger(__name__)
logger.setLevel(logging.INFO)

db_handler = MySQLHandler('host', 'user', 'password', 'database')
formatter = logging.Formatter('%(asctime)s - %(levelname)s - %(message)s')
db_handler.setFormatter(formatter)

logger.addHandler(db_handler)

logger.info('This is a test log message.')

pip install mysql-connector-python

import mysql.connector
from mysql.connector import Error
from datetime import datetime

def create_connection(host_name, user_name, user_password, db_name):
    connection = None
    try:
        connection = mysql.connector.connect(
            host=host_name,
            user=user_name,
            passwd=user_password,
            database=db_name
        )
        print("Connection to MySQL DB successful")
    except Error as e:
        print(f"The error '{e}' occurred")
    return connection

def insert_log_entry(connection, log_level, message, extra_info=None):
    query = """
    INSERT INTO log_entries (timestamp, log_level, message, extra_info)
    VALUES (%s, %s, %s, %s)
    """
    args = (datetime.now(), log_level, message, extra_info)
    cursor = connection.cursor()
    try:
        cursor.execute(query, args)
        connection.commit()
        print("Log entry added successfully")
    except Error as e:
        print(f"The error '{e}' occurred")

# Example usage
conn = create_connection("your_host", "your_username", "your_password", "your_database")
insert_log_entry(conn, "ERROR", "This is an error message", "Optional extra info")

pip install pymysql

import pymysql
from pymysql.err import MySQLError
from datetime import datetime

def create_connection(host_name, user_name, user_password, db_name):
    try:
        connection = pymysql.connect(host=host_name,
                                     user=user_name,
                                     password=user_password,
                                     database=db_name,
                                     cursorclass=pymysql.cursors.DictCursor)
        print("Connection to MySQL DB successful")
        return connection
    except MySQLError as e:
        print(f"The error '{e}' occurred")
        return None

def insert_log_entry(connection, log_level, message, extra_info=None):
    query = """
    INSERT INTO log_entries (timestamp, log_level, message, extra_info)
    VALUES (%s, %s, %s, %s)
    """
    args = (datetime.now(), log_level, message, extra_info)
    with connection.cursor() as cursor:
        try:
            cursor.execute(query, args)
            connection.commit()
            print("Log entry added successfully")
        except MySQLError as e:
            print(f"The error '{e}' occurred")

# Example usage
conn = create_connection("your_host", "your_username", "your_password", "your_database")
if conn:
    insert_log_entry(conn, "ERROR", "This is an error message", "Optional extra info")
    conn.close()