How to use ChatGPT for Senior Application Developer Job Role

python

import mysql.connector
from mysql.connector import Error

def fetch_data_from_table(host, database, user, password, table_name):
    try:
        # Establish a connection to the database
        connection = mysql.connector.connect(
            host=host,
            database=database,
            user=user,
            password=password
        )

        if connection.is_connected():
            print('Connected to MySQL database')
            cursor = connection.cursor()
            # Execute a query to fetch data from the specified table
            query = f'SELECT * FROM {table_name}'
            cursor.execute(query)
            # Fetch all rows from the executed query
            records = cursor.fetchall()
            print(f'Fetched {len(records)} rows from {table_name}')
            return records

    except Error as e:
        print(f'Error: {e}')
        return None

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()
            print('MySQL connection is closed')

python

host = 'localhost'
database = 'your_database'
user = 'your_username'
password = 'your_password'
table_name = 'your_table'

data = fetch_data_from_table(host, database, user, password, table_name)
print(data)