CBSE Class 12 Computer Science Question 36 of 47

Interface Python with SQL — Question 14

Back to all questions
14
Question

Question 14

Create a database TESTDB.

Answer
import mysql.connector
conn = mysql.connector.connect(host = 'localhost', 
                                user = 'root', 
                                passwd = 'tiger')
cursor = conn.cursor()
cursor.execute("CREATE DATABASE TESTDB")
conn.commit()
conn.close()