The cursor object is created by calling the cursor ( ) method of connection. The cursor is used to traverse the records from the result set.

cursor. description contains the details of each column headings. It will be stored as a tuple and the first one that is 0(zero) index refers to the column name. Using this command you can display the table's Field names.

SQlite_master is the master table which holds the key information about your database tables.

If a column of a table is declared to be an INTEGER PRIMARY KEY, then whenever a NULL is used as an input for this column, the NULL will be automatically converted into an integer which will be one larger than the highest value so far used in that column.

Create a connection using connect() method and pass the nanie of the database file.
Example:
#connecting to the database
connection = sqlite3.connect ("Academy.db")
#cursor
cursor = connection.cursor()

(i) "SELECT" is the most commonly used statement in SQL.
(ii) The SELECT Statement in SQL is used to retrieve or fetch data from a table in a database.
(iii) The syntax for using this statement is "Select * from table_name" and all the table data can be fetched in an object in the form of list of lists. List the classes used in

Aggregate functions are used to do operations from the values of the column and a single value is returned.
(i) COUNT ( )
(ii) AVG ( )
(iii) SUM ( )
(iv) MAX ( )
(v) MIN ( )

Step 1: Import sqlite3
Step 2: Create a connection using connect o method and pass the name of the database File
Step 3: Set the cursor object cursor = connection. cursor ( )

The WHERE clause is used to extract only those records that fulfill a specified condition. In this example we are going to display the different grades scored by male students from "student table.
import sqlite3
connection = sqlite3.connect ("Academy.db")
cursor = connection.cursor()
cursor.execute ("SELECT DISTINCT (Grade) FROM student where gender = "M")
result = cursor.fetchall()
print(* result, sep ="\n")
Output:
('B,')
('A,')
('C,')
('D,')

fetchone() fetchmany() Returns the next row of a query result set or none in case there is no row left.
Using while loop and fetchone() method we can display all the records from a table one by one. Returns the next number of rows(n) of the result set.
Displaying specified number of records is done by using fetchmany():  

Program:
import mysql db
db = mysqldb.connect ("local host", "user", "123", "organization'")
cursor = db.cursor()
item table creation
database: ABC, table: Item, lcode: int, ItemName: Char
Rate: int. Record: 1008, Monitor: 15000
cursor.execute ("Create table item(icode int, item Name char (25), Rate int"));
db.close
cursor. execute ("insert into item values ("1008", 'Monitor', '15000" ));
db.commit()

HAVING clause is used to filter data based on7the group functions. This is similar to WHERE condition but can be used , only with group functions. Group functions cannot be used in WHERE Clause but can be used in HAVING clause.
Example:
import sqlite3
connection = sqlite3.connect("Academy.db")
cursor = connection.cursorO
cursor.execute("SELECT GENDER,COUNT(GENDER) FROM Student GROUP BY GENDER HAVING COUNT( GENDER> 3")
result = cursor.fetchall( )
co = [i[o] for i in cursor. description]
print(co)
print(result)
Output:
['gender', 'COUNT(GENDER)']
[('M', 5)]