{"published":"2023-03-20 23:00:55","title":"MySQL \u7a7a\u9593\u60c5\u5831\u578b","type":"rich","description":"\u6e96\u5099 \u7a7a\u9593\u60c5\u5831\u306e\u578b \u7a7a\u9593\u60c5\u5831\u306e\u8868\u3057\u65b9 \u7a7a\u9593\u60c5\u5831\u306b\u5bfe\u3057\u3066\u306e\u95a2\u6570 \u5730\u7403\u4e0a\u306e\u4f4d\u7f6e\u60c5\u5831 \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 geosample; \u7a7a\u9593\u60c5\u5831\u306e\u578b \u7a7a\u9593\u60c5\u5831\u3092\u8868\u73fe\u3059\u308b\u578b\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002 \u578b\u540d \u610f\u5473 POINT \u70b9 LINESTRING \u7dda POLYGON \u9762\u2026","author_url":"https://blog.hatena.ne.jp/gesoges0/","provider_name":"Hatena Blog","author_name":"gesoges0","blog_title":"\u3081\u3082\u3061\u3087\u30fc","categories":["MySQL","SQL"],"url":"https://memo.geso.site/entry/2023/03/20/230055","height":"190","version":"1.0","blog_url":"https://memo.geso.site/","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmemo.geso.site%2Fentry%2F2023%2F03%2F20%2F230055\" title=\"MySQL \u7a7a\u9593\u60c5\u5831\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>","provider_url":"https://hatena.blog","width":"100%"}