We will be discussing MySQL COALESCE and NULLIF Function in this post . We will also be showing MySQL COALESCE examples and NULLIF mysql Function example COALESCE Function COALESCE in MySQL is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent […]
Web development
Top 10 Most Common MySQL queries examples
Useful and common MySQL queries examples for the developer and DBA’s 1)How to create mysql database mysql> create database techdb; mysql> use techdb; 2) How to create table in mysql database? .How to show the structure of the table after creation Here is the example for table creation in MySQL database 1) We need to […]
Top 51 Frequently Asked MySQL Interview Questions And Answers
Here is the compilation of Top 51 Frequently Asked MySQL Interview Questions And Answers,I hope you will like that and it will be useful in the interviews 1) What is the difference between sql and Mysql? Answer SQL or Structured Query Language is a programming language designed for managing data held in a Relational Database Management […]
Step by step guide to build local Apache PHP MySQL development environment on windows
A php developer would offcourse like to test the php file before deploying on the webserver.A local Apache PHP MySQL development environment on windows allows you to test your code as you develop your web application before publishing it to the web. This article will guide you through setting up a local Apache PHP MySQL development environment […]
Step-by-Step guide for Installing MySQL on Windows
The MySQL database server is one of the most popular open-source database servers commonly used in web application development.This document provides Step-by-Step guide for Installing MySQL on Windows. It covers the configuration details also with screen shot Starting the Download 1.Go to http://dev.mysql.com/downloads/installer/. 2.Click the Download button. 3. Scroll down to the MySQL database server & […]
PHP Functions with practical examples
PHP has the function capability as available with other programming languages What is a function? A function is a piece of code which takes one more input in the form of parameter and does some processing and returns a value.Suppose you have to call a piece of code several times in the process,then function will […]