PHP MySQL Database Introduction

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...

PHP mysqli_num_rows() Function

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...

SQL Datatypes

Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below.   1. Binary Datatypes : ...

SQL DDL, DML, TCL and DCL

In this article, we’ll be discussing Data Definition Language, Data Manipulation Language, Transaction Control Language, and Data Control Language. DDL (Data ...

SQL TRANSACTIONS

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...

SQL Comments

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...

Structured Query Language (SQL)

Structured Query Language is a standard Database language which is used to create, maintain and retrieve the relational database. What is Relational Database? Relatio...

SQL Views

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...

SQL SEQUENCES

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...

SQL Constraints

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...