Question

1. Write a Python program to create a database and a table with fields

Admno, Name, BirthDate, Stream, Marks.​

Answer 1

Answer:

Example

import mysql.connector.

#Create the connection object.

myconn = mysql.connector.connect(host = "localhost", user = "root",passwd = "google",database = "PythonDB")

#creating the cursor object.

cur = myconn.cursor()

try:

#adding a column branch name to the table Employee.