Computer Science C.B.S.E syllabus
CONSTRAINTS: A Constraint is a condition or checks applicable on a field or set of fields. Constraints are also known as integrity constraints because they applied to maintain data integrity. Two types of constraints: Column constraints: Apply only to individual columns. Table constraints: Apply to group of one or more columns. Syntax: CREATE TABLE…
MySQL Python Connectivity Commands #CREATE DATABASE import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″) mycursor=mydb.cursor() mycursor.execute(“CREATE DATABASE SCHOOL”) # SHOW DATABASE import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″) mycursor=mydb.cursor() mycursor.execute(“SHOW DATABASE”) for x in mycursor: print (x) # CREATE TABLE import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″,database=”student”) mycursor=mydb.cursor() mycursor.execute(“CREATE TABLE FEES (ROLLNO INTEGER(3),NAME VARCHAR(20),AMOUNT INTEGER(10));”) # SHOW TABLES import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″,database=”student”) mycursor=mydb.cursor() mycursor.execute(“SHOW TABLES”) for x in…
MySQL with Python Connectivity Notes import mysql.connector as m db = m.connect(host=”localhost”,user=”root”,passwd=”1234″) # Open database connection cursor = db.cursor() # prepare a cursor object using cursor() method cursor.execute(“show databases”) # execute SQL query using execute() method. data = cursor.fetchone() # Fetch a single row using fetchone() method. print (“Database version : %s ” % data)…
