If knowledge is power, then sharing knowledge is ultimate powertrip
PMP®, SAFe®5 POPM, SAFe®5 SSM, SAFe®5 SA, Prince2, MCP
Latest Updates
You are here: Home > 2013

Yearly Archives: 2013

Abstract Class vs Interface in php

In this article along with the demo project I will discuss Abstract class vs Interface in php. The concept of Abstract classes and Interfaces is a bit confusing for beginners of Object Oriented programming. Therefore, I am trying to discuss the theoretical aspects of both the concepts and compare their usage. And finally I will demonstrate how to use them ... Read More »

Difference between HAVING and WHERE Clause

The difference between having and where clause are given below. HAVING specifies a search condition for a group or an aggregate function used in SELECT statement. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. A HAVING clause is ... Read More »

Difference between group by and order by in mysql

The difference between group by and order by in mysql is as follow: ORDER BY alters the order in which items are returned. GROUP BY will aggregate records by the specified columns which allows you to perform aggregation functions on non-grouped columns (such as SUM, COUNT, AVG, etc). Read More »

Difference between distinct and group by in mysql

The difference between DISTINCT and GROUP BY in Mysql is that they usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to remove duplicates then use DISTINCT. If you are using sub-queries execution plan for that ... Read More »

Full Text Search in MySQL

MySQL supports text searching by using the LIKE statement and regular expression. However, when the text column is large and the number of rows in a table is increased, using those methods has limitations: Performance: MySQL has to scan the whole table to find the exact text based on pattern in the LIKE statement or pattern in the regular expressions. Flexible search: with the LIKE statement and regular expression ... Read More »

MySQL Cheat Sheet

MySQL Cheat Sheet for your reference. Working with Database Create a database with a specified name if it does not exist in database server 1 CREATE DATABASE [IF NOT EXISTS] database_name Use database or change current database to another database you are working with 1 USE database_name Drop a database with specified name permanently. All physical file associated with the database is no longer exists. 1 DROP DATABASE [IF EXISTS] database_name Show all available databases ... Read More »

Triggers in MySql

Triggers in mysql  is a set of Sql statements stored in the database catalog. A Sql trigger is executed or fired whenever an event associated with a table occurs e.g.,  insert, update or delete. Triggers in mysql is a special type of stored procedure. It is special because it is not called directly like a stored procedure. The main difference between a trigger and ... Read More »

Difference between InnoDB and MyISAM

Few difference between InnoDB and MyISAM are as: MYISAM: MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI) MYISAM not supports transaction. You cannot commit and rollback with ... Read More »

Convert PHP date to javascript date

We can convert PHP date to javascript date as; var dateStr=”2011-08-03 09:15:11″; //returned from mysql timestamp/datetime field var a=dateStr.split(” “); var d=a[0].split(“-“); var t=a[1].split(“:”); var date = new Date(d[0],(d[1]-1),d[2],t[0],t[1],t[2]); Read More »

Scroll To Top