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.
We have to configure the security settings for the SNMP-Service on a Windows Server. But they are missing!
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. […]
There are different types of joins available in SQL: INNER JOIN OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN INNER JOIN: (the typical Join operation, which uses some comparison operator like = or ). These include equi-joins and natural joins. Inner Joins use a comparison operator to match rows from two tables […]
PROBLEM Since MySQL doesn’t seem to have any ‘boolean’ datatype, which datatype do we ‘abuse’ for storing true/false information in MySQL? Especially in the context of writing and reading from/to a PHP-Script. The several approaches are : tinyint, varchar fields containing the values 0/1, varchar fields containing the strings ‘0’/’1′ or ‘true’/’false’ And finally enum […]