{"author_url":"https://blog.hatena.ne.jp/gesoges0/","width":"100%","height":"190","type":"rich","categories":["MySQL","SQL"],"version":"1.0","author_name":"gesoges0","published":"2023-03-21 00:02:35","title":"MySQL JSON\u578b","image_url":null,"provider_url":"https://hatena.blog","provider_name":"Hatena Blog","url":"https://memo.geso.site/entry/2023/03/21/000235","description":"\u6e96\u5099 JSON\u578b\u30ab\u30e9\u30e0\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210 JSON\u578b\u306e\u30ec\u30b3\u30fc\u30c9\u306e\u633f\u5165 \u5024\u306e\u62bd\u51fa \u914d\u5217\u306e\u64cd\u4f5c \u53c2\u8003 \u6e96\u5099 $ sudo docker run --platform linux/x86_64 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest $ mysql -uroot -pmy-secret-pw -h127.0.0.1 -P3307 mysql > create database jsonsample; JSON\u578b\u30ab\u30e9\u30e0\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210 mysql> CREATE TABLE menu (id INT NOT\u2026","blog_title":"\u3081\u3082\u3061\u3087\u30fc","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmemo.geso.site%2Fentry%2F2023%2F03%2F21%2F000235\" title=\"MySQL JSON\u578b - \u3081\u3082\u3061\u3087\u30fc\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://memo.geso.site/"}