Форум пользователей MySQL

DROP PROCEDURE IF EXISTS `set_macuid2`;
DELIMITER $$
CREATE PROCEDURE `set_macuid2` (IN usr_uid INT, IN usr_ip VARCHAR(15), IN usr_mac VARCHAR(12))
BEGIN
  DECLARE uid_pool INT DEFAULT 0;

  SELECT uid INTO uid_pool FROM ip_pool WHERE ip=INET_ATON(usr_ip) AND uid = usr_uid LIMIT 1;

  IF ( uid_pool > 0 ) THEN
    UPDATE mac_uid SET ip = INET_ATON(usr_ip)
        WHERE uid=usr_uid
          AND mac = usr_mac;
  END IF;
END$$
DELIMITER ;;

mysql> CALL set_macuid2 (4455,'11.22.33.44','e48d8c4c74fb');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;
+---------+------+-----------------------------------------------------+
| Level   | Code | Message                                             |
+---------+------+-----------------------------------------------------+
| Warning | 1329 | No data - zero rows fetched, selected, or processed |
+---------+------+-----------------------------------------------------+
1 row in set (0.00 sec)