Mysql tips

To format a select with a nice table:

select * from blah where id=wibble \G

Note the lack of ; on the end

http://mysql.rjweb.org/doc.php/mysql_analysis#tuning

restore a large db possibly set trx possibly autocommit link to sed nnd for nuking certain imports starting the lock monitors

"{"12261":"merged"}"

SELECT id, viewing, JSON_CONTAINS(viewing, JSON_QUOTE('merged')) , JSON_KEYS(viewing) FROM scoring_app_infos where id = 2779042

SELECT JSON_UNQUOTE(viewing), id, viewing, JSON_CONTAINS(JSON_UNQUOTE(viewing), JSON_QUOTE("merged"), '$."12261"') , JSON_KEYS(JSON_UNQUOTE(viewing) ) FROM scoring_app_infos where id = 2779042

Page created on 6 Jun 2020