This is the first video on the SQL(Structural Query language) tutorial series. In this tutorial, we will learn how to install the latest version of the MySQL server and MySQL workbench on windows.
Category: How To
How to enable Developer Tab in Excel(Excel macro)
By default, The Developer tab is not visible in the excel menu bar we have to enable it. We can easily add by selecting the developer check box from the Customize ribbon option. Please follow the below steps to enable the Developer tab in excel.
How to Create a New User Account in CentOS
Most of the operation can be done in two ways i.e. via user interface and via the command line interface (CLI). This turotial of creating new user in CentOS will be donw via the command line terminal. Tutorial covers topics such as creation of user, adding a password, deleting user ans listing the user information.
Convert any format of the image to jpg format using python.
In this tutorial, we are going to learn how to convert the image format into jpg and other formats. Before starting the coding, please make sure you have installed the pillow library into your system. If you have not installed the pillow module yet install it using the following command.
How To send email using python.
Simple mail transfer protocol (SMTP) is an application layer protocol that transfers an email from one user to another user. As a software developer or programmer, we need to send lots of plain text email and also an email with reports, query results, images, text data, application form data, etc to the business client from a different …
HOW TO CREATE NEW PROCESS WITH FORK IN PYTHON?
fork() is an operation whereby a process creates a copy of itself. It is usually a system call, implemented in the kernel. With this system call, it creates a child process that runs concurrently with the process that created it (Parent Process).
How to Force/forward HTTPS using .htaccess
Now that you registered a domain say domianname.com when people have to look for your website, they will be landed on the URL http://domainname.com. But Http:// is not a safe place for adding your important information. Every website, almost every website these days try to keep their website, web application safe.
How to configure Environment Specific settings in Python Django Framework?
There are certain configurations in your settings.py such as DEBUG, STATIC_URL, DATABASES, SECRET_KEY, ALLOWED_HOSTS, etc. These settings are actually the ones that you need to look after while deploying to the production environment. Whenever your application goes live, you shouldn’t display your debug logs, or error messages on the browsers. This will make your application vulnerable. Also you might want to put different secret keys.
Pandas DataFrame: Join Two CSVs keeping data of all columns
The parameters “lsuffix”, and “rsuffix” keep the column names of both CSVs. You can also perform a left join, right join, and other operations by adding another parameter “how”. The how parameter takes how : {‘left’, ‘right’, ‘outer’, ‘inner’} options. The default one is left join.
WARNINGS (URLs.W005) URL namespace ‘admin’ isn’t unique. You may not be able to reverse all URLs in this namespace
Lets jump into this minor issue you face while running Django migrations. The issue also has a quick fix. The issue is encountered when we type the following command in your terminal: