http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Thu, 21 Feb 2013 12:12:48 +0000 en-US hourly 1 https://wordpress.org/?v=5.3.3 32412571 Merging tables with INSERT…ON DUPLICATE KEY UPDATE https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update#comments Thu, 21 Feb 2013 12:12:48 +0000 https://shlomi-noach.github.io/blog/?p=6120 https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update/feed 3 6120 Pop quiz: funny syntax https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax#comments Mon, 05 Nov 2012 18:22:15 +0000 https://shlomi-noach.github.io/blog/?p=5445 https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax/feed 1 5445 MySQL joins: ON vs. USING vs. Theta-style https://shlomi-noach.github.io/blog/mysql/mysql-joins-on-vs-using-vs-theta-style https://shlomi-noach.github.io/blog/mysql/mysql-joins-on-vs-using-vs-theta-style#comments Wed, 11 Jul 2012 04:54:20 +0000 https://shlomi-noach.github.io/blog/?p=5050 https://shlomi-noach.github.io/blog/mysql/mysql-joins-on-vs-using-vs-theta-style/feed 15 5050 Syntax of the day: IS TRUE and IS FALSE https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false#comments Thu, 26 Jan 2012 04:09:23 +0000 https://shlomi-noach.github.io/blog/?p=4198 https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false/feed 4 4198 Quoting text JavaScript/Python style https://shlomi-noach.github.io/blog/mysql/quoting-text-javascriptpython-style https://shlomi-noach.github.io/blog/mysql/quoting-text-javascriptpython-style#comments Tue, 15 Nov 2011 06:11:37 +0000 https://shlomi-noach.github.io/blog/?p=4364 https://shlomi-noach.github.io/blog/mysql/quoting-text-javascriptpython-style/feed 2 4364 MySQL terminology: processes, threads & connections https://shlomi-noach.github.io/blog/mysql/mysql-terminology-processes-threads-connections https://shlomi-noach.github.io/blog/mysql/mysql-terminology-processes-threads-connections#comments Wed, 03 Nov 2010 06:38:03 +0000 https://shlomi-noach.github.io/blog/?p=2465 https://shlomi-noach.github.io/blog/mysql/mysql-terminology-processes-threads-connections/feed 3 2465 SQL: good comments conventions https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions#comments Thu, 01 Jul 2010 07:36:32 +0000 https://shlomi-noach.github.io/blog/?p=2581 https://shlomi-noach.github.io/blog/mysql/sql-good-comments-conventions/feed 5 2581 Views: better performance with condition pushdown https://shlomi-noach.github.io/blog/mysql/views-better-performance-with-condition-pushdown https://shlomi-noach.github.io/blog/mysql/views-better-performance-with-condition-pushdown#comments Thu, 20 May 2010 05:17:05 +0000 https://shlomi-noach.github.io/blog/?p=1328 https://shlomi-noach.github.io/blog/mysql/views-better-performance-with-condition-pushdown/feed 1 1328 Discovery of the day: GROUP BY … DESC https://shlomi-noach.github.io/blog/mysql/discovery-of-the-day-group-by-desc https://shlomi-noach.github.io/blog/mysql/discovery-of-the-day-group-by-desc#comments Tue, 04 May 2010 09:38:38 +0000 https://shlomi-noach.github.io/blog/?p=2381 https://shlomi-noach.github.io/blog/mysql/discovery-of-the-day-group-by-desc/feed 4 2381 But I DO want MySQL to say “ERROR”! https://shlomi-noach.github.io/blog/mysql/but-i-do-want-mysql-to-say-error https://shlomi-noach.github.io/blog/mysql/but-i-do-want-mysql-to-say-error#comments Fri, 12 Mar 2010 04:53:28 +0000 https://shlomi-noach.github.io/blog/?p=2005 https://shlomi-noach.github.io/blog/mysql/but-i-do-want-mysql-to-say-error/feed 18 2005