Hi folks here is the short tip to check the duplicate data in MySQL.
Checking for Duplicate Rows
To prevent duplicate rows in a database table is to put a unique index on the column, but sometime comes as dirty …
SQL Window Function – part 1
Hi folks here in this article we are going to see what is window function in SQL, and how it is useful for data analyst for data preprocessing or generation accumulated data with lots of information, combination of calculation and …
Google Charts in PHP with MySQL Database using Google API
“Google Charts in PHP with MySQL Database using Google API”, Pie Chart, Column Chart, Bar Chart, Line Chart. Charts or graph are used for graphical representation of data and are useful when you want to show your data or information …
Learn MySQL Important Queries – Part 2
Hello friends, I’m going to discuss the second part Learn MySQL Important Queries, In the previous part, we learned basic and essential part of MySQL queries. In this part, we’ll learn about some advanced query that will help you in …
Learn MySQL Important Queries – Part 1
Everyone Know MySQL is an open-source relational database management system (RDBMS). Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. Every web developer should know MySQL. It …
Export Data from MySQL in PHP Using Data Table
In this tutorial “Export Data from MySQL in PHP Using Data Table” we are going to learn about how to display the data and extract data from database using DataTable.js. The grid view of the table is very …
Live Username Availability Check using PHP
Creating a form that tells you that your entered data already exist in the database and you don’t need to enter again. This is very famous functionality adopted by almost all top social companies like Facebook and Twitter.
In this …
Display data from MySQL database using PHP, jQuery and DataTable
In this tutorial “Display data from MySQL database using PHP, jQuery and DataTable” we are going to learn about how to display the data from database using DataTable.js. The grid view of the table is very important for …
Login with Google Account Using PHP
In this tutorial “Login with Google Account Using PHP” we are going to learn about setting up an authentication system for your custom web application using Google OAuth PHP and save the data into MySQL database. Today social …
Pagination with jQuery Ajax PHP and MySQL
In this tutorial “Pagination with jQuery Ajax PHP and MySQL”, we are going to learn how to implement pagination in any project with PHP and MySQL. In any web project, pagination functionality is an essential part where huge …