Recent Posts
C | 3 sec ago
C# | 35 sec ago
C# | 50 sec ago
None | 1 min ago
None | 3 min ago
C | 4 min ago
None | 4 min ago
Bash | 5 min ago
C++ | 6 min ago
Java | 6 min ago
Sitereport
Find cool info about any domain on the internet?
visit sitereport
Free Subdomains
Want a pastebin.com sub-domain for your community?
learn more...
What is pastebin?
Pastebin is a website that hosts all your text & code on dedicated servers for easy sharing.
learn more...
By Anonymous on the 9th of Feb 2010 11:11:21 PM
Download |
Raw |
Embed |
Report
CREATE PROCEDURE pegarTudoEmUmaLinha()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE linha, idCampo VARCHAR(255);
DECLARE queryDesejada CURSOR FOR SELECT id FROM tabela1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
OPEN queryDesejada;
REPEAT
FETCH queryDesejada INTO idCampo;
SET linha = CONCAT(linha," ",idCampo);
UNTIL done
END REPEAT;
SELECT linha;
CLOSE queryDesejada;
END
Submit a correction or amendment below.
[ previous version ] | [ difference ] | Make A New Post