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
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 be thrown: PDO can do that, depending on how you configure it See PDO::setAttribute and PDO::ATTR_ERRMODE and PDO::ERRMODE_EXCEPTION else, with some other API, you might have to test the result […]
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 that is YYYY-mm-dd and but we want that to be in regional or in some other format. using strtotime and date function printing only date using strtotime and date function […]
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 with foreign key support (Declarative Referential Integrity). It is included as standard in most binaries distributed by MySQL AB, the exception being some OEM versions. InnoDB became a product of Oracle Corporation after its acquisition of Innobase Oy in October 2005. The software is dual licensed; it is distributed under […]
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 the need for a transaction, and without violating standards. In this article we explained several ways to write such queries in a platform-independent way. Several solutions: One solution […]
Temporary Tables Temporary Tables are a great feature that lets you store and process intermediate results by using the same selection, update, and join capabilities that you can use with typical SQL Server tables. The temporary tables could be very useful in some cases to keep temporary data. Types There are mainly two types of Temporary Tables-Local & Global Temporary Tables. […]