Re: stored procedure truncating

[Peter Brawley]

drop procedure if exists t;
delimiter go
create procedure t()
begin
  UPDATE joblisttable 
  INNER JOIN joblistfromdevice 
  ON joblisttable.jobnumber=joblistfromdevice.jobnumber 
  SET joblisttable.jobstart= joblistfromdevice.jobstart; 

  DELETE joblistfromdevice 
  FROM joblistfromdevice 
  INNER JOIN joblisttable ON joblisttable.jobnumber=joblistfromdevice.jobnumber; 
end;
go
delimiter ;
show create procedure t\G
*************************** 1. row ***************************
           Procedure: t
            sql_mode: NO_ENGINE_SUBSTITUTION
    Create Procedure: CREATE DEFINER=`pietari`@`%` PROCEDURE `t`()
begin
  UPDATE joblisttable
  INNER JOIN joblistfromdevice
  ON joblisttable.jobnumber=joblistfromdevice.jobnumber
  SET joblisttable.jobstart= joblistfromdevice.jobstart;

  DELETE joblistfromdevice
  FROM joblistfromdevice
  INNER JOIN joblisttable ON joblisttable.jobnumber=joblistfromdevice.jobnumber;
end
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ci
  Database Collation: utf8_general_ci