The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers
«
»

MySQL function result reuse in expressions?

Posted by jpluimers on 2024/07/18

I love how Kris answers with these concise bits of SQL query results, this time about the sleep function and expression reuse of function results:

  1. [Wayback/Archive] Kris on Twitter: “libera/#mysql: “Hello! Does mysql reuse the result of expression evaluation during query execution?…”
    mysql> select sleep(1)+sleep(1) as s;
+---+
| s |
+---+
| 0 |
+---+
1 row in set (2.00 sec)
  2. [Wayback/Archive] Kris on Twitter: “… suggests an index on sleep“

Reference: [Wayback/Archive] MySQL :: MySQL 8.0 Reference Manual :: 12.24 Miscellaneous Functions

–jeroen

This entry was posted on 2024/07/18 at 12:00 and is filed under Database Development, Development, MySQL, SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

«
»