READ Operation

Categories: Python

READ Operation on any database means to fetch some useful information from the database.


Once our database connection is established, you are ready to make a query into this database. You can use either fetchone() method to fetch single record or fetchall() method to fetech multiple values from a database table.

fetchone() − It fetches the next row of a query result set. A result set is an object that is returned when a cursor object is used to query a table.

fetchall() − It fetches all the rows in a result set. If some rows have already been extracted from the result set, then it retrieves the remaining rows from the result set.

rowcount − This is a read-only attribute and returns the number of rows that were affected by an execute() method.


Update Operation

UPDATE Operation on any database means to update one or more records, which are already available in the database.

The following procedure updates all the records having SEX as 'M'. Here, we increase AGE of all the males by one year.

DELETE Operation

DELETE operation is required when you want to delete some records from your database. Following is the procedure to delete all the records from EMPLOYEE where AGE is more than 20.


Top articles
What is used of Python? Some uses with practical Python Published at:- Some Advanced Features of Python and Its uses Published at:- Python Interview Question and Answer Published at:- Python Introduction Published at:- Benefits of Python Programming Language Published at:- Introduction to Careers in Python Published at:- Advantages of Python Published at:- AWS Control Tower now supports Python 3.9 runtime Published at:- Hello World using Python Program. Published at:- Features of Python Published at:- History of Python Published at:- Loper al Environment Setup of Python Published at:- Getting Python on the Appliper ation Published at:- Python Identifiers Published at:- Lines and Indentation in the Python Published at:- Multi-Line Statements in the python Published at:- Quotation in Python Published at:- Comments in Python Published at:- Using Blank Lines in Python Published at:- Assigning Values to Variables in the Python Published at:- Multiple Assignment in the Python Published at:- Standard Data Types Published at:- Python Comment Published at:- Multiple Python Statement in One Line on the Comment Published at:- Strings Python Statements In Comment Published at:- Python Indentation Published at:- What are Python Variables? Published at:- Python Strings Published at:- Python String Program Published at:- Python Lists Published at:- Python Tuples Published at:- Python Dictionary Published at:- Data Type Conversion Published at:- Different Types of Operators in the Python Published at:- Python Arithmetic Operators Published at:- Python Comparison Operators Published at:- Python Assignment Operators Published at:- Python Bitwise Operators Published at:- Python Logical Operators Published at:- Python Membership Operators Published at:- Python Identity Operators Published at:- Highest Precedence in Python Operators Published at:- Python - Decision Making Published at:- Single Statement In Python Published at:- Functions in Python Published at:- Defining a Function Published at:- Syntax in Python Published at:- Example of Python Published at:- Calling a Function Published at:- Function Arguments Published at:- Required arguments Published at:- Keyword arguments Published at:- Default arguments Published at:- Variable-length arguments Published at:- The Anonymous Functions Published at:- The return Statement Published at:- Scope of Variables Published at:- Global vs. Local variables Published at:- Default arguments Published at:- Variable-length arguments Published at:- The Anonymous Functions Published at:- The return Statement Published at:- Python - Modules Published at:- The import Statement Published at:- Locating Modules Published at:- The PYTHONPATH Variable Published at:- Namespaces and Scoping Published at:- The dir( ) Function Published at:- The globals() and locals() Functions Published at:- The reload() Function Published at:- Packages in Python Published at:- Python - Files I O Published at:- The raw_input Function Published at:- The input Function Published at:- Opening and Closing Files Published at:- The open Function Published at:- The file Object Attributes Published at:- The close() Method Published at:- Reading and Writing Files Published at:- The read() Method Published at:- File Positions Published at:- Renaming and Deleting Files Published at:- The remove() Method Published at:- Directories in Python Published at:- The chdir() Method Published at:- The getcwd() Method Published at:- The rmdir() Method Published at:- File & Directory Related Methods Published at:- Python - Exceptions Handling Published at:- Assertions in Python Published at:- The assert Statement Published at:- What is Exception? Published at:- Handling an exception Published at:- Argument of an Exception Published at:- Raising an Exceptions Published at:- User-Defined Exceptions Published at:- Python - Object Oriented Published at:- Overview of OOP Terminology Published at:- Creating Classes Published at:- Creating Instance Objects Published at:- Accessing Attributes Published at:- Built-In Class Attributes Published at:- Destroying Objects Published at:- Class Inheritance in Python Published at:- Base Overloading Methods Published at:- Overloading Operators in Python Published at:- Data Hiding Published at:- Python - Object Oriented Published at:- Creating Instance Objects Published at:- Accessing Attributes Published at:- Built-In Class Attributes Published at:- Class Inheritance Published at:- Python - CGI Programming Published at:- Web Browsing in Python Published at:- Web Server Support and Configuration In Python Published at:- HTTP Header In Python Published at:- CGI Environment Variables Published at:- Passing Information using GET method Published at:- Simple FORM Example:GET Method In Python Published at:- Passing Information Using POST Method In Python Published at:- Passing Radio Button Data to CGI Program Published at:- Passing Text Area Data to CGI Program Published at:- Using Cookies in CGI Published at:- How It Works In Python ? Published at:- Setting up Cookies In Python Published at:- How To Raise a "File Download" Dialog Box? Published at:- Python - MySQL Database Access Published at:- What is MySQLdb? Published at:- Database Connection In Python Published at:- Creating Database Table In Python Published at:- Python - Regular Expressions Published at:- The match Function Published at:- Regular Expression Modifiers: Option Flags Published at:- Regular Expression Patterns Published at:- What is Sockets? Published at:- The socket Module Published at:- Server Socket Methods Published at:- General Socket Methods Published at:- What is Simple Server Published at:- A Simple Client Published at:- Python Internet modules Published at:- Further Readings Published at:- Python - Sending Email using SMTP Published at:- Sending an HTML e-mail using Python Published at:- Sending Attachments as an E-mail Published at:- Python - Multithreaded Programming Published at:- Starting a New Thread Published at:- Python Lambda Published at:- Python Dictionaries Published at:- Ordered or Unordered? Published at:- Python Casting Published at:- What is an Array? Published at:- Python Iterators Published at:- Python Scope Published at:- Global Scope Published at:- Python Dates Published at:- What is PIP? Published at:- File Handling Published at:- Python File Open Published at:- Python File Write Published at:- NumPy Tutorial Published at:- Python - MySQL Database Access Published at:- What is MySQLdb? Published at:- Database Connection in Python Published at:- READ Operation Published at:- Python Tools Utilities Published at:- Python - Multithreaded Programming Published at:- Synchronizing Threads Published at:- Python - XML Processing Published at:- Python - GUI Programming Published at:-
R4Rin Team
The content on R4Rin.com website is created by expert teams.