Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
mysql_notes [2019/11/06 04:34]
root [Json Functions]
mysql_notes [2019/11/06 04:35] (current)
root [Json Functions]
Line 29: Line 29:
    '​{ "​name":​ "​Safari",​ "​os":​ "​Mac",​ "​resolution":​ { "​x":​ 1920, "​y":​ 1080 } }'    '​{ "​name":​ "​Safari",​ "​os":​ "​Mac",​ "​resolution":​ { "​x":​ 1920, "​y":​ 1080 } }'
 )'); )');
 +</​code>​
 +
 +and the select like sql
 +
 +<code sql>
 +SELECT id, browser->'​$.name'​ browser
 +FROM events;
 </​code>​ </​code>​
 == XML Functions ==  == XML Functions == 
 
mysql_notes.txt · Last modified: 2019/11/06 04:35 by root
 
RSS - 200 © CrosswireDigitialMedia Ltd