Creating a Database

☞ To create a database, we need to perform following steps :

Step 1 : Import mysql.connector module and open a connection

Step 2 : Create cursor object

Step 3 : Execute a query

☞ Example :

import mysql.connector as m
mydb = m.connect(host='localhost', user='root', password='123')

cur = mydb.cursor()    #creating cursor object
cur.execute(“CREATE DATABASE IF NOT EXISTS school”)      #executing a query

#following lines are to show the result in python shell
cur.execute(“SHOW DATABASES”)
for i in cur:
      print(i)

☞ Output :

(‘information_schema’,)
(‘school’,)
(‘mysql’,)
(‘office’,)
(‘performance_schema’,)

Note : You can also see the result in MySQL database.

Previous Topic Next Topic

📘 Classs XI : Revision of Python

📝 Chapter 1: Basics of Python

📝 Chapter 2: Operators in Python

📝 Chapter 3: Decision-Control in Python

📝 Chapter 4: Loops in Python

📝 Chapter 5: String in Python

📝 Chapter 6: List in Python

📝 Chapter 7: Tuples in Python

📝 Chapter 8: Dictionary in Python

📘 Unit 1: Computational Thinking & Programming-2

📝 Chapter 1: Functions in Python

📝 Chapter 2: Exception Handling in Python

📝 Chapter 3: File Handling in Python

📝 Chapter 4: Data Structure in Python

📘 Unit 2: Database Management

📝 Chapter 1: DBMS-MySQL

📝 Chapter 2: Interface of Python with SQL

📘 Unit 3: Computer Network

📝 Chapter 1: Computer Networks

Creating a Database