Queue in Data Structure A queue or FIFO (first in, first out) is an abstract data type that serves as a collection of elements, with two principal
Category - Database
Latest Articles and Errors& Fixes of popular RDBMS like Sql server, Oracle, MYSQL and more
How Hackers Use SQL Injections to Get Access of Websites - Hacking - check vulnerable site add (‘) at end of URL and if you get sql error in your syntax.
mysql installation problem -We find “Error 0” commonly occurs when there is a previous installation of MySQL on a Windows
We have to configure the security settings for the SNMP-Service on a Windows Server. But they are missing!
How to install check_mysql_health plugin in nagios - "check_mssql_health" script.You will find a "check_mssql_health.pl" which you better ignore.
SOLUTION :1 We generally use when working with transactions looks like this (semi-pseudo-code): Note that, with this idea, if a query fails, an Exception must...
Date is important aspect in developing applications such as storing user registration date time ,last login time, date of birth etc. Mysql has standard format...
InnoDB InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along...
How to write INSERT IF NOT EXISTS queries in standard SQL If necessary, INSERT IF NOT EXISTS queries can be written in a single atomic statement, eliminating...
Temporary Tables Temporary Tables are a great feature that lets you store and process intermediate results by using the same selection, update, and join...
