MySQL Examples and Tutorials
In this tutorial, we will learn how to delete the data from the MySQL table from the PHP program. It is as simple as inserting data into the table and can be done in a few lines of code. We will see all three methods i.e., update using MySQLi procedural, MySQLi object-oriented and PDO. So, …
Python is a general-purpose high-level programing language. It is used in many areas such as server-side web development, data science, computational mathematics, software development, and so on. Python can also be used in database applications. In this tutorial, we’ll learn to use python to connect to the MySQL database. Setting Up Python and MySQL Let’s …
In this tutorial, we will see how can we retrieve the data from the MySQL table and display it on the webpage using PHP. Retrieving data from the MySQL table is a simple process. However, fetching all the data from the table and displaying it on the webpage in the proper manner requires you to …
A prepared statement is excelled feature provided by PHP-MySQL to increase the speed and execution of the query. It is one of the best ways to execute a similar query or a statement with high efficiency. However, it seems a little bit tricky for PHP-MySQL beginners. However, it’s quite simple and only requires a couple …
In this tutorial, we will learn to insert multiple records in a MySQL database using the PHP program. This is a very simple tutorial which consists of multiple ways and methods to insert multiple records such as mysqli and PDO. Let’s dive into it! Before We Start There are two approaches for inserting multiple records …
In this tutorial, we’ll learn what a primary key is, How to create a primary key using CREATE table or using ALTER table statement, and how to drop a primary key using MySQL. Also read: MySQL CREATE TABLE – How to create a table in MySQL? Introduction to MySQL Primary Key The concept of keys …
In this tutorial, we will study Unique Constraints in MySQL. We will learn about the column and table level unique constraints with examples. Without further ado, let’s get started! Introduction to MySQL Unique Constraint Unique Constraints in MySQL are used to ensure that the data stored in a column or a combination of columns is …
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 …
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 …
In this tutorial, we will learn how to list users in the MySQL database. We will use the SELECT statement to list all users in the mysql.user table. Introduction In MySQL, there is no such command as show table or show database for getting a list of users. So the syntax for the same is …