Re: strange thing about use trigger

[Devart Team]

>but i find one record has not been updated correctly

Do you mean not all records have been updated? Have a look at the trigger - the SELECT statement finds all matched rows, but LIMIT clause selects only one row from data-set; and you are trying to update only this one. I'd suggest you to use this statement instead of SELECT+UPDATE, try it -

UPDATE Interface_Data.Conf_List
SET
  CallBeginTime = NEW.`CallBeginTime`,
  CallEndTime = NEW.`CallEndTime`,
  CallTimer = NEW.`CallTimer`,
  BillSource = NEW.`BillSource`
WHERE
  BillNum = NEW.BillNum
  AND CallerNum = New.CallerNum
  AND CalledNum = New.CalledNum
  AND CallBeginTime = '';

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/