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 Functions mysql

MySQL BIN() Function

The BIN() function in MySQL is used to convert a decimal number to its binary equivalent.The BIN() function is equivalent to the CONV() function written in the format...
SQL mysql SQL

IFNULL in MySQL

Given a TABLE, in this TABLE, it prints entry of the table. If table is empty then it gives NULL. Examples: QUESTION : Given an employee table, print name from the gi...
DBMS SQL mysql

MySQL Regular expressions (Regexp)

MySQL supports another type of pattern matching operation based on the regular expressions and the REGEXP operator. It provide a powerful and flexible pattern match ...
SQL mysql SQL

MySQL RENAME USER

The RENAME USER statement can be used in MySQL if a MySQL administrator wants to change the username or the host of an existing MySQL user account without altering th...
DBMS SQL mysql

MySQL Grant / Revoke Privileges

Granting Privileges We have already learned about how to create user in MySQL using MySQL | create user statement. But using the Create User Statement only creates a...
SQL mysql SQL-Functions

MySQL LAST_DAY() Function

The LAST_DAY() function in MySQL can be used to know the last day of the month for a given date or a datetime. The LAST_DAY() function takes a date value as argument ...
SQL Web Technologies mysql

MySQL Change User Password

In MySQL, the user account password can be changed using 3 different statements: UPDATE statement SET PASSWORD statement ALTER USER statement. But before changing t...
SQL mysql SQL

MySQL CREATE USER Statement

MySQL allows us to specify which user account can connect to a database server. The user account details in MySQL contains two information – username and host ...

Subscribe to Our Newsletter