Tutorialspoint.dev
Welcome To Tutorialspoint.dev
Officially launched 18th May 2019
PHP SQL Technical Scripter

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 Web Technologies PHP-function

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 SQL-basics SQL

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 : ...
DBMS SQL Technical Scripter

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 SQL-basics SQL

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...
Articles DBMS SQL

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...
DBMS DBMS-SQL SQL-basics

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...
Articles DBMS SQL

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 DBMS-SQL SQL-basics

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...
DBMS SQL SQL-basics

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

Subscribe to Our Newsletter