What is MySQL?
MySQL is an open-source relational database management system (RDBMS). It is the most popular database system used with PHP. MySQL is developed, distri...
Share
The mysqli_num_rows() function is an inbuilt function in PHP which is used to return the number of rows present in the result set. It is generally used to check if da...
Share
Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below.
 
1. Binary Datatypes :
...
Share
In this article, we’ll be discussing Data Definition Language, Data Manipulation Language, Transaction Control Language, and Data Control Language.
DDL (Data ...
Share
What are Transactions?
Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the...
Share
As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet.
Comments can be written i...
Share
Structured Query Language is a standard Database language which is used to create, maintain and retrieve the relational database.
What is Relational Database?
Relatio...
Share
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from o...
Share
Sequence is a set of integers 1, 2, 3, … that are generated and supported by some database systems to produce unique values on demand.
A sequence is a user d...
Share
Constraints are the rules that we can apply on the type of data in a table. That is, we can specify the limit on the type of data that can be stored in a particular c...
Share