http://postgres.cz/index.php?action=history&feed=atom&title=MySQL5%3A_Gentle_introduction_to_stored_procedures_of_MySQL5 2026-04-15T17:11:35Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=MySQL5:_Gentle_introduction_to_stored_procedures_of_MySQL5&diff=1394&oldid=prev 2025-07-23T11:37:46Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 23. 7. 2025, 11:37</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l569">Řádek 569:</td> <td colspan="2" class="diff-lineno">Řádek 569:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In this article I didn´t describe the entire functionality of stored procedures. I missed out e.g. triggers, protection, characteristic of function (DETERMINISTIC|NON DETERMINISTIC|MODIFIES SQL DATA etc).... Neither I tried to describe it. I haven´t met any person yet who would use SP in MySQL5 in real applications. At present it´s so hot new and I guess that it will take at least one year until all mistakes are debugged and until programmers get used to it – see the coming of PHP5.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In this article I didn´t describe the entire functionality of stored procedures. I missed out e.g. triggers, protection, characteristic of function (DETERMINISTIC|NON DETERMINISTIC|MODIFIES SQL DATA etc).... Neither I tried to describe it. I haven´t met any person yet who would use SP in MySQL5 in real applications. At present it´s so hot new and I guess that it will take at least one year until all mistakes are debugged and until programmers get used to it – see the coming of PHP5.</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">-----</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;center&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;htmlet&gt;wide-banner&lt;/htmlet&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;/center&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1387:rev-1394:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=MySQL5:_Gentle_introduction_to_stored_procedures_of_MySQL5&diff=1387&oldid=prev 2025-07-23T11:35:14Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 23. 7. 2025, 11:35</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[category:Articles]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[category:Articles]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Translated by Věra Peterová</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Translated by Věra Peterová</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;div style="padding:20px; float: right;"&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;div style=" border: solid thin lightgrey; padding:10px;"&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;htmlet&gt;reklama&lt;/htmlet&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;/div&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;/div&gt;</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>I started to write this article before Christmas when I was excited about the fact that MySQL supported the stored procedures (SP). This quality was some time called the most expected and useful benefit of MySQL 5.0. Therefore a lot of articles about this topic appeared. As a surprise, after the first euphoria, the interest of SP rapidly failed. Unfortunately, the first versions of MySQL comprised a lot of mistakes which weren´t took out as fast as they should have been. And the implementation of stored procedures didn´t avoid the mistakes as well. When I wanted to finish the article, I had to wait for the elimination of mistake which made the recursive calling of procedure impossible. Again, in the version 5.1, the development of stored procedures is still difficult regarding the miserable diagnostics of mistakes and the number of uncorrected mistakes or missing qualities of the language. In regard of the fact that MySQL is practically the last O.S. database where the stored procedures are implemented, the language of stored procedures comes from ANSI SQL and at the point of syntaction it´s the most similar O.S. database to SQL/PSM. I have already mentioned that the integrity and quality of SP is not comparable to e.g. Postgres of Firebird. I understand that the priorities of MySQL are somewhere else: clustering, partitioning and replication. The examples which I give in this article are debugged in MySQL 5.1.9 and don´t have to work in other versions.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>I started to write this article before Christmas when I was excited about the fact that MySQL supported the stored procedures (SP). This quality was some time called the most expected and useful benefit of MySQL 5.0. Therefore a lot of articles about this topic appeared. As a surprise, after the first euphoria, the interest of SP rapidly failed. Unfortunately, the first versions of MySQL comprised a lot of mistakes which weren´t took out as fast as they should have been. And the implementation of stored procedures didn´t avoid the mistakes as well. When I wanted to finish the article, I had to wait for the elimination of mistake which made the recursive calling of procedure impossible. Again, in the version 5.1, the development of stored procedures is still difficult regarding the miserable diagnostics of mistakes and the number of uncorrected mistakes or missing qualities of the language. In regard of the fact that MySQL is practically the last O.S. database where the stored procedures are implemented, the language of stored procedures comes from ANSI SQL and at the point of syntaction it´s the most similar O.S. database to SQL/PSM. I have already mentioned that the integrity and quality of SP is not comparable to e.g. Postgres of Firebird. I understand that the priorities of MySQL are somewhere else: clustering, partitioning and replication. The examples which I give in this article are debugged in MySQL 5.1.9 and don´t have to work in other versions.</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-264:rev-1387:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=MySQL5:_Gentle_introduction_to_stored_procedures_of_MySQL5&diff=264&oldid=prev 2013-09-06T19:14:51Z

<p></p> <a href="http://postgres.cz/index.php?title=MySQL5:_Gentle_introduction_to_stored_procedures_of_MySQL5&amp;diff=264">Ukázat změny</a>

imported>Pavel