Skip to content

Tag Archives: mysql

In this article, we will discuss how to create an Activate/Deactivate button using PHP. When a particular status is set, the same gets updated in… Read More
In many scenarios, we may need to create a dropdown input that can display all the options consistent with the current state of the database.… Read More
In this article, SQL and its applications in Data Analysis and Machine Learning are discussed. We will also discuss SQL’s various applications and its future… Read More
We will learn how to Backup and Restore your MySQL Database with Mysqldump query in LINUX.  We had always a need that if the production… Read More
MySQL is an open-source relational database management system based on Structured Query Language(SQL). It is a relational database that organizes data into one or more… Read More
In MySQL date is a data type and by default follows the format ‘YYYY-MM-DD’ but by using date formatting functions we can format date and… Read More
In this article, we will discuss the overview of SQL and will mainly focus on Concepts and Queries and will understand each with the help… Read More
The aim of this article is to make a simple program to Join two tables using Join and Where clause using MySQL. Below is the… Read More
AND, OR, NOT operators are basically used with WHERE clause in order to retrieve data from table by filtering with some conditions using AND, OR,… Read More
In this article, we will learn how to configure SQL jobs in SQL Server using T-SQL. Also, we will discuss the parameters of SQL jobs… Read More
In this article, let us discuss the overview of the foreign key in SQL and the main focus will be on how to delete a… Read More
In this article, we will discuss the overview of foreign keys and will discuss how to add a foreign key using ALTER in MySQL step… Read More
A Web Stack or Web application stack refers to a compilation of software that is together used to build websites or web applications. To construct… Read More
Django is a Python-based web framework that allows you to quickly create efficient web applications. It is also called batteries included framework because Django provides… Read More
In this article, we are going to find minimum and maximum details from the table column using PHP from MySQL Xampp server. We are taking… Read More