waflessnet

Untitled

Sep 24th, 2013
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.35 KB | None | 0 0
  1. CREATE PROCEDURE userEstadisticas(IN IDUSER INT)
  2.     BEGIN
  3.         DECLARE N INT;
  4.         DECLARE S INT;
  5.         DECLARE T INT;
  6.         DECLARE F INT;
  7.         SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
  8.         SET N= CALL userNosigo(IDUSER);
  9.         SET S= CALL userSigo(IDUSER);
  10.         SET T= CALL userTotalFriends(IDUSER);
  11.         SET F= CALL userTotalFollowers(IDUSER);
  12.         SELECT N,S,T,F;
  13.     END
Advertisement
Add Comment
Please, Sign In to add comment