DROP TABLE tablename; DROP command is used for deleting the table and its structure from the data base.Use this command when you don’t need that table any more. Other Spec: 1. Removes a table from the database.Table structures, indexes, privileges, constraints will also be removed. 2. Cannot be rolled back. 3. No Triggers can…
Social network by internet giant is “Google+” getting popular exponentially and of course they already have a huge customer database and all they have to do is to promote this new product among them.However people know the fact that Google+ is very special kind of social network with very unique features. In parallel to…
Recursion and recursive routines is a bit more complicated, it can be defined as a regular function that calls itself. Learning when and how to apply recursion is probably a lot more difficult than just learning what recursion is? and being able to explain recursion effectively in an interview situation is even more difficult…
Equal and Identical comparison operators in PHP When comparing values in PHP for equality you can use either the == (equal) operator or the === (identical) operator. Do you know, what is the difference? Very simple the == operator just checks to see if the left and right values are equal. But, the === operator…
Hopefully, you can think that !== operator as being more ‘strict’ than the != operator. This is because the !== operator will say that the two operands being compared are not equal only if the type of the two operands are the same, but their values are not equal. This is desirable behaviour because the…
ACID(Atomicity Consistency Isolation Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. Atomicity Atomicity is an all-or-none proposition. Modifications on the data in the database either fail or succeed. Each transaction is said…
