MySQL UNION Operator and comparison to UNION ALL
This article is all about MySQL UNION Operator and a guide on how to efficiently use this operator....
Tag: MySQL
Create Pagination in PHP and MySQL – Complete code
In this tutorial, I am going to show full code to create pagination with PHP and MySQL. Usually, S...
Concept of pagination by SQL Query in MySQL
Before digging deep the Concept of pagination using PHP and MySQL, I would like to introduce you wi...
MySQL Interview Questions Frequently Asked
MySQL Interview Questions In this article on frequently asked MySQL Interview Questions, I am go...
MySQL Data Types – a complete list
MySQL supports a number of SQL data types. These data types can be divided in several categories: n...
MySQL CASE In WHERE CLAUSE: Conditional conditions
Before proceeding to know how to use MySQL CASE in where clause, be sure to be aware of what a MySQ...
Fetch different columns conditionally using MySQL CASE
Before using MySQL CASE to fetch different columns based on condition, i.e. using where clause to s...
MySQL CONCAT() AND CONCAT_WS() functions
MySQL CONCAT() functionMySQL CONCAT_WS() function MySQL CONCAT() function MySQL CONCAT() func...
How to export MySQL database using Command Prompt or batch file
To export MySQL database from command Line a set of commands need to be executed. Follow the steps ...
MySQL CHAR and VARCHAR Types
The CHAR and VARCHAR types are String Types in MySQL as they store string (or say text type) data. ...