Mysql tips

To format a select with a nice table:

select * from blah where id=wibble \G

Note the lack of ; on the end

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


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