MySQL Python Connectivity

Your Name

Full form of API

• Application Process Interchange

• Application Programs Interchange

• Application Process Interface

• Application Programming Interface

Python needs a MySQL driver to access the MySQL database. State True/False

(a)  

Connector Library to connect MySQL with Python IDLE is

• pymysql

• mysql.connector

• both a and b

• none of these

import mysql.connector as mys

Here mys is called

(a)  

import mysql.connector as mys

mydb = mys.connect( host="localhost", user="root",

password="root"

)

mycursor = mydb.cursor()

mycursor.execute("CREATE DATABASE KVSEC3")

AFTER EXECUTING THE ABOVE CODE. What will be done

(a)  

To display all the databases of MySQL with the help of cursor mycursor , command will be

• mycursor.execute("SHOW DATABASES")

• mycursor.execute("DESC DATABASES")

• mycursor.executes("SHOW DATABASES")

• mycursor.execute("SHOW ALL DATABASES")

Correct the error if any

mycursor = mydb.cursor()

mycursor.execute("CREATE TABLE customers (name VARCHAR(25), 'address' VARCHAR(55))")

• mycursor.execute('CREATE TABLE customers (name VARCHAR(25), 'address' VARCHAR(55))')

• mycursor.execute("CREATE TABLE customers (name VARCHAR(25), address VARCHAR(55))')

• mycursor.execute("CREATE TABLE customers (name VARCHAR(25), address VARCHAR(55));")

• mycursor.execute("CREATE TABLE customers (name VARCHAR(25), address VARCHAR55))")

After inserting the data we need to issue

• rollback

• set autocommit

• mycur.commit(1)

• mycur.commit()

To close a connection (CON) we Use

(a)