Tag Archives: MySQL

mysql date_format() list

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

Posted in Programming | Tagged , , , , | Leave a comment

mysql_error() function in php

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”; ?>

Posted in Programming | Tagged , , , | Leave a comment

Effective Data warehousing

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

Posted in Featured | Tagged , , , , , , , , | Leave a comment

Data integration and mash ups

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

Posted in ndot.in | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment