Category Archives: mysql

MySQL COALESCE and NULLIF Function

Last updated on October 30th, 2018 at 04:25 amWe will be discussing MySQL COALESCE and NULLIF Function  in this post with lot of examples. COALESCE Function COALESCE Function 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 to the following IF-THEN-ELSE statement IF val1 is not NULL THEN … Continue reading MySQL COALESCE and NULLIF Function »

Top 51 Frequently Asked MySQL Interview Questions And Answers

Last updated on June 21st, 2018 at 10:45 amHere 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 System. Mysql … Continue reading Top 51 Frequently Asked MySQL Interview Questions And Answers »

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 on windows Step 1. Download the installation files First of … Continue reading Step by step guide to build local Apache PHP MySQL development environment on windows »

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 & standard clients section and Select the latest production release 3.Save the … Continue reading Step-by-Step guide for Installing MySQL on Windows »