Guest User

Untitled

a guest
Dec 14th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. PREPARE stmt1 FROM
  2. "select ...quite complex select from tenth of tables..
  3. and `subscribers`.`id` = ?
  4. group by `subscribers`.`id`
  5. limit 1";
  6. SET @a = 77586744;
  7. EXECUTE stmt1 USING @a;
  8. DEALLOCATE PREPARE stmt1;
  9.  
  10. SET @sql = CONCAT("select ...quite complex select from tenth of tables..
  11. and `subscribers`.`id` = ",77586744,"
  12. group by `subscribers`.`id`
  13. limit 1");
  14. PREPARE stmt1 FROM @sql;
  15. EXECUTE stmt1 ;
  16. DEALLOCATE PREPARE stmt1;
Add Comment
Please, Sign In to add comment