TYaXaW6Y

1('n[ Error ]nt Error Message:t ', OperationalError(2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)"), 'n')
2	
3import pymysql
4import sys
5
6try:
7    # database connection string
8    database = pymysql.connect("localhost", "username", "password", "databasename")
9    # prepare cursor object this metod
10    cursor = database.cursor()
11    # create database
12    create = '''CREATE DATABASE databasename'''
13
14    cursor.execute(create)
15
16    # drop table if it already exist
17    cursor.execute("DROP TABLE IF EXISTS TimeTable")
18
19    # SQL Command line
20    sql = """CREATE TABLE TimeTable (
21            id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
22            Types VARCHAR(45) NOT NULL COMMENT '',
23            LectureTime VARCHAR(45) NOT NULL COMMENT '',
24            LectureTeacher VARCHAR(45) NOT NULL COMMENT '',
25            Lesson VARCHAR(45) NOT NULL COMMENT '',
26            Place VARCHAR(45) NOT NULL COMMENT '',
27            Days VARCHAR(45) NOT NULL COMMENT '')"""
28
29    # execute current sql command from create table
30    cursor.execute(sql)
31    # disconnect from the server
32    database.close()
33    print("Database and Table Created")
34except Exception as e:
35    print("n[ Error ]nt Error Message:t ", e, "n")
36    sys.exit(1)