PW Akshay

Generation

generate functionSun, 27 Nov 2022

create a school data management python project using mysql

def create_school_database(school_name): connection = mysql.connect() cursor = connection.cursor() school_db_name = school_name.lower().replace(' ', '_') query = 'CREATE DATABASE IF NOT EXISTS {}'.format(school_db_name) cursor.execute(query) connection.commit() connection.close() cursor.close()

Questions about programming?Chat with your personal AI assistant