Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @v1 = '';
- SET @v2 = '';
- SET @Query = CONCAT('SELECT sum(colName1), sum(colName2) INTO @v1, @v2 FROM tableName WHERE id=1 ');
- PREPARE stmt FROM @Query;
- EXECUTE stmt;
- DEALLOCATE PREPARE stmt;
- SET @Query = CONCAT('SELECT id, name,',@v1,' as value1, ',@v2,' as value2 FROM tableName WHERE id=1 ');
- PREPARE stmt FROM @Query;
- EXECUTE stmt;
- DEALLOCATE PREPARE stmt;
- SET @Query = 'SELECT id, name, ? as value1, ? as value2 FROM tableName WHERE id=1 ');
- PREPARE stmt FROM @Query;
- EXECUTE stmt USING @v1, @v2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement