GeoNotes

I needed to update a column with the date and time whenever a record changed in my database. So here is the recipe for the trigger in MySQL 5.0.
DELIMITER $$
CREATE    /*[DEFINER = { user | CURRENT_USER }]*/    TRIGGER `my_database`.`UpdatedOn` BEFORE UPDATE    ON `my_database`.`my_table`    FOR EACH ROW BEGINset NEW.update_on = now();    END$$
DELIMITER ;

Here is a
Here is a script (below) you can use to copy dump files between machines using scp from an
automated script. Please see attached. The script usage is as
follows:
./auto_scp.sh  
local_file   user@host:remote_folder  
user_password
or
./auto_scp.sh  
user@host:remote_file   local_folder  
user_password
Example:
./auto_scp.sh   dump.dmp   oracle@hostname:/U01/oracle
  <oracle password>
and here is the script————————————————–
#!/usr/bin/expect -f
# connect via scpspawn scp “[lindex $argv 0]” “[lindex $argv 1]” #############################################expect {-re “.*es.*o.*” {exp_send “yes\r”exp_continue}-re…