Python – Using JSON
Python has a built-in package called json, which can be used to work with JSON data to store and exchange data.
Python – Working with Try and Except
A Python try block lets you test a block of code for errors. And the except block lets you handle the error.
Python – Formatting Strings
There are two ways to format strings in Python: Using F-strings (the preferred way since v3.6) and the format() method (older and less efficient).
Python – Opening Files
The key function for working with files in Python is the open() function, which takes two parameters: filename, and mode.
Python – Reading Files
In Python, the open() function will open the file and the read() method is used to read the content of the file.
Python – Writing to a File
In Python, the open() function is used to open or create a file and then a parameter is set to write contents to the file.
Python – Deleting a File
In Python, to delete a file, the OS module is imported, and the os.remove() function is used.
Python – Creating a MySQL Database
In Python, the “CREATE DATABASE” statement is used to create a MySQL database.
Python – Connecting to a MySQL Database
Python can be used in database applications to connect to a MySQL database to interact with stored information.
Python – Creating a MySQL Table
In Python, the “CREATE TABLE” statement is used to create a MySQL table.
Python – Adding Data to a MySQL Table
In Python, the “INSERT INTO” statement is used to add data to a MySQL table.
Python – Retrieving Data From a MySQL Table
In Python, the “SELECT” statement is used to get data from a MySQL table.
Python – Using “WHERE” to Retrieve Data From a MySQL Table
In Python, the “WHERE” statement is used to get filtered data from a MySQL table.
Python – Using “ORDER BY” to Order Data From a MySQL Table
In Python, the ORDER BY keyword is used to sort the resulting data in either ascending or descending order.
Python – Using “LIMIT” When Retrieving Data From a MySQL Table
In Python, the “LIMIT” statement is used to limit the number of records returned from a MySQL table.
Python – Updating Data in a MySQL Table
In Python, the “UPDATE” statement is used to make changes to existing data in a MySQL table.
Python – Deleting Data From a MySQL Table
In Python, the “DELETE FROM” statement is used to remove data from a MySQL table.
Python – Joining Two or More MySQL Tables
In Python, the “JOIN” statement is used to combine rows from two or more tables, based on a related column they share.