Search In
A trigger is SQL code which runs just before or just after an
INSERT, UPDATE or DELETE event occurs on a particular database table.
Creating a Trigger:
Consider we have two tables:
CREATE TABLE `blog` (
`id` mediumint(8) unsigned NOT NULL AU
Database creation using PostgreSQL
To start work with postgres, you need to install Postgres. To download PostgreSQL 9.1, go through below link:
Download
To check that you are able to access psql, open cmd and fire command psql.
If you are getting
There are number of institutes which provides QA training in India.Some of The best QA training institute in India are listed below :
QSpiders :
Software industry keeps on doing changes day by day and improving, so do technology updates, Qspiders we
INTRODUCTION:
Static import in Java allows to import static members of class and use them, as they are declared in the same class, means access any static member of class directly without using class name. Like regular import statements, static impo
Code for those Apps where we need to update user's current location in regular interval of time even if app is in background state.
In Appdelegate.h write this code:-
@property (nonatomic,strong) UIBackgroundTaskIdentifier *bgTask;
In AppDelegate.
Here is some basic information about Linux.
Linux is basically a UNIX operating system, it is a open source OS which is easily available in market, Linux is made with only one thought in mind :- Everything is a file.
Means almost everything you do o
Optimization of database tables in mysql is a methodology which must be done frequently to make your database healthy.
As per mysql manual,
OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many chan
Cross-site scripting
Cross-site scripting or XSS is a web attack at application layer. XSS rather than targeting the script embedded in a page executed on the server side, it tagets the script executed on the client side. In XSS attack, the hacker i
Most of us probably know that EM was very popular back in the days of IE6 and other browsers that didn’t support “full site zooming” (like moving your head closer to the screen, ctrl and + to zoom in, ctrl and – to zoom out). Loads of sites had butto
Sometime we need to migrate theme from one installation another. We can do this easily by following the below steps:
1). Create a new theme in Liferay 6.2 using this command.
./create.sh themename “ThemeDisplayName”
themename = The Name of your
