Python Database API Overview
Uploaded by
amoghstudy18Python Database API Overview
Uploaded by
amoghstudy188
" c arraysize)
cclose)
cexecute(sql. params) " Python database APl supports a wide range of
database servers such as Godfly, MySQL, Oracle,
" [Link](sql, seq-of-params) Sybase etc.
Cursor obi abaseAPI
It provides a minimal standard for working with
and m database.
tal
Database object method
" close)
" commit) OSWA L
cursor0
Jnterface of Pythan
rollback(0
with an SQL database CBSE
Sample
Cursor MySQLdb " MySQLdb is an interface for connecting to a Question
MySQL database servers from Python.
" Connet method or MySQLdb interface is used to
" A cursor is a Python object that enables reate a connection object using MySQLdb module. Papers,
you to work with the database.
" It is positioned at a particular location
within a table in the database. Trace the Mind Map
First Level Second Level Third Level COMPUTER
SCIENCE,
Clas-12