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...
MySQL
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. ...
How to extend group_concat() limit in MySQL & phpMyAdmin
To extend group_concat() limit in MySQL there are two methods, either using SQL command or by setti...
SQL – Structured Query Language: Basics of SQL
SQL is an abbreviation for Structured Query Language, usually pronounced as separate letters "S-Q-L...
Database Management System (DBMS)
Database Management System is software which is used to manage database is called Database Managemen
How to connect MySQL database in PHP – PHP MySQL
Before learning how to connect MySQL database in PHP, I would like to give a brief introduction abou
Database connection in PHP using PDO – PHP PDO
Database Connection in PHP Before starting to database connection I would like to explain why we...