Sarthaks Test
0 votes
844 views
in Information Technology by (53.6k points)

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details(3,’Michelle’,’Agartala’) in a“student”table.

1 Answer

+1 vote
by (53.8k points)
selected by
 
Best answer

import mysql.connector

mydb = mysql.connector.connect{

host="localhost",

user="root",

passwd="cbse",

database="school"

}

mycursor = mydb.cursor()

mycursor.execute("INSERT INTO student values(3,'Michelle', 'Agartala');")

mydb.commit()

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...