Wordpress - biswajitroutray.wordpress.com - biswajitroutray
General Information:
Latest News:
Stored procedure 4 Oct 2011 | 11:46 pm
Stored procedures are set of SQL commands that are stored in the database data server. After the storing of the commands is done, the tasks can be performed or executed continuously, without being rep...
Transactions 4 Oct 2011 | 07:18 am
A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. In other words, a transaction will never be complete unless each individ...
Storage Engines 2 Oct 2011 | 11:04 pm
MyISAM MyISAM is the default storage engine as of MySQL 3.23. It is based on the ISAM storage engine but has many useful extensions. Each MyISAM table is stored on disk in three files. The files hav...
SQL Injection 2 Oct 2011 | 10:53 pm
SQL injection is an attack that allows the attacker to add logical expressions and additional commands to an existing SQL query. This attack can succeed whenever a user submits data that is not proper...
MySql Indexing 2 Oct 2011 | 10:40 pm
The main purpose of the index is to find rows quickly – without scanning whole data set. This is most typical reason index gets added on the first place. Types of Indexes Primary Key Indexes Unique...
Concepts that every experienced should know 30 Sep 2011 | 05:07 pm
Q: What is T_PAAMAYIM_NEKUDOTAYIM? This is an error,the double colon (::) is used to access static & overriden methods and members in PHP. The T_PAAMAYIM_NEKUDOTAYIM error is thrown when you’re tryin...
Image functions 30 Sep 2011 | 05:26 am
For image related functions GD library is used, it has ability to construct images on the fly, like charts and graphs. Additionally, it can be used in other manners, such as handling uploaded images a...
