DOB blog

Skip to content
  • Home
  • About
  • Contact
  • Hire Me

SQL

MySQL/MariaDB Split Comma Separated String Into Table

root2019-11-112019-11-11

As you know, in MySQL/MariaDB there is no native function for splitting string column by comma or by some regex into a table. In PostgreSQL we a great function regexp_split_to_table for this, but in mysql compatible world it was not possible (till some time ago) to do this without complicated workarounds. Fortunately with introduction of […]

mysql, rdbms, SQL, Uncategorized

MySQL JSON diff

root2017-10-222019-11-11

Simple function that compares two JSON structures (on 1st level only), and returns old values for changed keys. I’m using it to track table changes via before update trigger.

devel, how-to, mysql, rdbms, SQL

Recent Posts

  • MySQL/MariaDB Split Comma Separated String Into Table
  • Fixing Postfix sender_bcc_maps not working with PostSRSd
  • Exposing SOLR search API securely with Nginx and Lua
  • Fix for Gentoo: The ebuild phase ‘die_hooks’ has been aborted
  • Fix invalid node IP in /etc/pve/.members

Archives

  • November 2019
  • June 2019
  • March 2019
  • July 2018
  • October 2017
  • April 2017
  • March 2017
  • January 2017
  • December 2016
  • September 2016
  • February 2016
  • December 2015
  • October 2015
  • September 2015
  • April 2015
  • November 2014
  • July 2014
  • June 2014
  • March 2014
  • March 2013
  • May 2012
  • April 2012
  • February 2012
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • January 2011
  • April 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009

Categories

  • admin
  • c/c++
  • cm
  • devel
  • dmlquery
  • eldap
  • how-to
  • log-malloc2
  • lua
  • LVM
  • mail server
  • MariaDB
  • mysql
  • network
  • nginx
  • pager
  • passwd-exp
  • performance
  • perl
  • personal
  • Proxmox
  • rdbms
  • security
  • solr
  • solr
  • SQL
  • time saver
  • tinc
  • Uncategorized
  • virtualization
  • vpn
  • web
  • xml
  • xsl

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Theme: FlatBox by Wpbars, Powered by WordPress