Archive for the ‘Database’ Category

5 Mar

Funny SQL Procedure

Posted by milansaha in Database.

Groom writes:

CREATE PROCEDURE
MyMarriage BrideGroom Male (25) , Bride Female(20) AS BEGIN
SELECT
Bride FROM Bangladesh_ Brides
WHERE FatherInLaw = ‘Millionaire’
AND Count(Car) > 20 AND HouseStatus =’ThreeStoreyed’
AND BrideEduStatus IN (BSc ,BA ,Degree ,CA ,MBA)
AND Having Brothers= Null
AND [...]

Continue reading »

24 Feb

Data Manipulation Language(DML)

Posted by milansaha in Database.

Data Manipulation Language (DML) is a family of computer languages used by computer programs database users to retrieve, insert, delete and update data in a database.
Currently the most popular data manipulation language is that of SQL, which is used to retrieve and manipulate data in a Relational database. Other forms of DML are those used [...]

Continue reading »

17 May

Which one is Faster ….InnoDB Or MyISAM ?

Posted by milansaha in Database, PHP. Tagged: , .

In web development MySQL is nowadays widely used database.So speed is a major issue for all operations of MySQL . But which DB engine should be used to execute a insert operation in MySQL. MyISAM or InnoDB ? Well i had a test to track the execution time for this two types of DB engine. [...]

Continue reading »