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
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. […]
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 […]