A stored procedure is a segment of declarative SQL code, which is
stored in the database catalog. A stored procedure can be invoked by a
program, a trigger or even another stored procedure. A stored procedure which calls itself is recursive stored procedure.
Almost RDMBS supports recursive stored procedure but MySQL does not
support it well. You should check your version of MySQL database before
implementing recursive stored procedures.
JAVA FlowLayout
The FlowLayout is the simplest layout manager. By default, it puts all the components into a row in the order they are added to the container from left-to-right. If the row meets the end of the container then a new row is started beneath.
JAVA Editors Tools
If you are new to Java programming, you are probably starting by using notepad. When you want to compile and run a program, you need to open a DOS window and type javac MyProgram.java and java MyProgram. Also, what you type is what you get: notepad does not help you any way with Java syntax or design. This is fine if you are just starting, and even experts sometimes use command-line Java options.
JAVA Integrated Development Environment (IDE)
An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, build automation tools and a debugger.
BorderLayout on Java
A border layout lays out a container, arranging and resizing its components to fit in five regions: north, south, east, west, and center. Each region may contain no more than one component, and is identified by a corresponding constant: NORTH, SOUTH, EAST, WEST, and CENTER.
GridLayout on Java
The GridLayout class is a layout manager that lays out a container's components in a rectangular grid. The container is divided into equal-sized rectangles, and one component is placed in each rectangle. For example, the following is an applet that lays out 3 textfields and 3 labels into three rows and two columns:
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Monday, December 17, 2012
Thursday, December 13, 2012
Create Triggers in MySQL - Tutorial 1
What are triggers? What are they used for?
A trigger is a set of code which is executed in response to some event.
E.g Update employee_perfomance table when a new task is inserted in task table. Here, the trigger is “update” and the event is “inserting a new row”.
A trigger in MySQL is created using CREATE TRIGGER trigger_name. We need to specify the trigger type.
Triggers can be used for actively control, monitor, and manage a group of tables whenever an insert, update, or delete operation is performed.
