Tag Archives: MySQL

mysql date_format() list

Posted on March 10, 2011 by saran

DATE_FORMAT() function formats the date by specifying a sequence of format strings. A string is composed of the percentage symbol ‘%’ followed by a formatting letter. These are some of the more common strings to use: Specifier Description %a Abbreviated … Continue reading →

  • October 14, 2012 |
  • 0 Comments
Posted in Programming | Tagged , , , , | Leave a comment

mysql_error() function in php

Posted on December 27, 2010 by saran

Use of mysql_error() in php <?php $link = mysql_connect(“localhost”, ”mysql_user”, ”mysql_password”); mysql_select_db(“nonexistentdb”, $link); echo mysql_errno($link) . ”: ” . mysql_error($link). ”\n”; mysql_select_db(“kossu”, $link); mysql_query(“SELECT * FROM nonexistenttable”, $link); echo mysql_errno($link) . ”: ” . mysql_error($link) . ”\n”; ?>

  • October 14, 2012 |
  • 0 Comments
Posted in Programming | Tagged , , , | Leave a comment

Effective Data warehousing

Posted on June 7, 2010 by techie

Data warehousing applications do not typically process small requests but rather massive queries across specific dimensions such as time, geography, customer, product, etc. These queries may require seconds, minutes, or even hours of processing time depending on database software and … Continue reading →

  • October 14, 2012 |
  • 0 Comments
Posted in Featured | Tagged , , , , , , , , | Leave a comment

Data integration and mash ups

Posted on May 8, 2010 by techie

Data Integration is concerned with combining data from various Sources into one consistent stream. It provides an essential Single View of Data, for example, a Single View of a Customer. Various resources may be necessary for a business so that … Continue reading →

  • October 14, 2012 |
  • 0 Comments
Posted in ndot.in | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment