Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. DECLARE a int;
  2. SET @a = CONCAT('SET @num = (SELECT COUNT(*) FROM ', p_tblName, 'WHERE agent_id = ', id')',);
  3. PREPARE stmt FROM @a;
  4. EXECUTE stmt;
  5. SET a = @num;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement