· 8 years ago · Nov 03, 2017, 06:34 PM
1
2
3import mysql.connector
4from mysql.connector import Error
5
6def connect():
7 try:
8 conn=mysql.connector.connect(host='localhost',user='root',password='root')
9
10 if(conn.is_connected()):
11 print('Connected to MySQL database')
12 cursor=conn.cursor()
13 cursor.execute("""CREATE DATABASE Recipe_Data""")
14 cursor.execute("""USE Recipe_Data""")
15 cursor.execute("""DROP IF TABLE EXISTS Recipe_Info""")
16 sql = """CREATE TABLE Recipe_Info (Recipe_Name CHAR(80) NOT NULL,Recipe_Id INT(20))"""
17 cursor.execute(sql)
18 sql="""SHOW TABLES"""
19 except Error as e:
20 print(e)
21 finally:
22 conn.close()