Database

delimiter //
   drop procedure if exists example_cursor;
   create procedure example_cursor() reads sql data
   begin
    -- declare variables
    declare var_wage numeric(8,2);
    declare var_employee_id int;
    declare var_department_id int;

    -- declarar done state
    declare done int default 0;

    -- create cursor for table
    declare cur1 cursor for
    select employee_id, salary, department_id from employees;

    -- set done to 1 if data wasn't found
    declare continue handler for not found set done = 1;

    -- open cursor
    open cur1;
    -- start loop
    emp_loop:loop
       -- get data from cursor
       fetch cur1 into var_employee_id, var_wage, var_department_id;
    if(done = 1) then
       leave emp_loop;
     end if;
    end loop emp_loop;
    -- close cursor
    close cur1;
end;
 //

CREATE TABLE `employees` (
  `EMPLOYEE_ID` int(11) NOT NULL auto_increment,
  `SURNAME` varchar(40) NOT NULL,
  `FIRSTNAME` varchar(40) NOT NULL,
  `ADDRESS1` varchar(40) NOT NULL,
  `ADDRESS2` varchar(40) NOT NULL,
  `ZIPCODE` varchar(6) NOT NULL,
  `DATE_OF_BIRTH` datetime NOT NULL,
  `PHONENO` varchar(12) NOT NULL,
  `MANAGER_ID` decimal(8,0) NOT NULL,
  `SALARY` decimal(8,0) NOT NULL,
  `STATUS` varchar(9) NOT NULL,
  `DEPARTMENT_ID` decimal(8,0) default NULL,
  `COMMENT_ID` decimal(8,0) default NULL,
  `DEPARTMENT_NAME` varchar(40) default NULL,
  `ADJUSTED_SALARY` decimal(8,0) default NULL,
  `HIRE_DATE` datetime default NULL,
  PRIMARY KEY  (`EMPLOYEE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE [dbo].[MyTable] ADD  CONSTRAINT [DF_MyTable_MyDateColumn]  DEFAULT (getdate()) FOR [MyDateColumn]
GO

ALTER TABLE [dbo].[MyTable] ADD  DEFAULT ((0)) FOR [MyBitColumn]
GO