Comments on: SQL: good comments conventions https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions Blog by Shlomi Noach Mon, 05 Jul 2010 05:15:07 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Comment your MySQL schema « Electricmonk.nl weblog https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions/comment-page-1#comment-15470 Mon, 05 Jul 2010 05:15:07 +0000 https://shlomi-noach.github.io/blog/?p=2581#comment-15470 […] SQL: good comments conventions […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions/comment-page-1#comment-15380 Fri, 02 Jul 2010 17:45:06 +0000 https://shlomi-noach.github.io/blog/?p=2581#comment-15380 @Roland,
Glad I could bring up the past 🙂

@Shantanu,
sounds painful!

]]> By: Shantanu Oak https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions/comment-page-1#comment-15377 Fri, 02 Jul 2010 13:09:21 +0000 https://shlomi-noach.github.io/blog/?p=2581#comment-15377 Apart from comments I do also use different cases like SeLeCt or selecT. Then I use ‘grep’ command to find the query from log file.

]]> By: Daniël van Eeden https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions/comment-page-1#comment-15374 Fri, 02 Jul 2010 06:27:19 +0000 https://shlomi-noach.github.io/blog/?p=2581#comment-15374 It’s too bad that it’s not possible to add a comment to a CREATE DATABASE

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions/comment-page-1#comment-15365 Thu, 01 Jul 2010 21:40:21 +0000 https://shlomi-noach.github.io/blog/?p=2581#comment-15365 It’s funny you should mention sakila and comments….way, way, waaaay back when Mike Hillyer created the database, I proposed to put all documentation in comments, and use an XML export in combination with an XSLT stylesheet to generate the schema documentation into a HTML format.

Alas, the comment fields are way to small to seriously use them for this purpose. Anyway…you reminded me of an inspiring past. Thanks!

]]>