MySQL Examples and Tutorials

MySQL Percent_Rank() Function

In this tutorial, we will study Percent_Rank() function in MySQL. This function takes a column name as the argument and returns the number of rows with greater values than the sample value. Without further ado, let’s get started! Introduction to MySQL Percent_Rank() The Percent_Rank() function is one of many useful functions that are available in …

MySQL Percent_Rank() Function Read More »

MySQL Replace – Addon Uses

In this tutorial, we will study REPLACE() function in MySQL to insert and update data in tables. Also read: MySQL REPLACE() – Edit Strings and Replace Values in MySQL Introduction to MySQL REPLACE() In MySQL, Replace statement is used to replace the data in the tables. The process is executed by inserting a new row …

MySQL Replace – Addon Uses Read More »

MySQL Format Function

The Format function in MySQL is a very useful and advanced formatting tool that allows you to format the output of certain SQL values according to your requirements. In this tutorial, we will learn how to use the Format function in order to format dates and numbers into the desired style. Introduction The Format Format …

MySQL Format Function Read More »

PHP MySQL Create Table

In this tutorial, we will learn to create a table in MySQL using PHP. You might have created a table from the MySQL CLI or other GUI tools such as MySQL workbench or phpMyAdmin. But in this tutorial, we will create a PHP program that will create a table when we run that script. We …

PHP MySQL Create Table Read More »