Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQLクイズ at テテミート #2 / MySQL Quiz at Tetemeet vol2

MySQLクイズ at テテミート #2 / MySQL Quiz at Tetemeet vol2

2023年3月17日に開催されたテテマーチ社主催のLTイベント「テテミート #2」で、みんな大好きMySQLについてのクイズを出題しました。

https://tetemarche.connpass.com/event/277407/

pinkumohikan

April 05, 2023
Tweet

More Decks by pinkumohikan

Other Decks in Technology

Transcript

  1. ΫΠζ
    'SJ
    !QJOLVNPIJLBO

    View full-size slide

  2. ✔ ͽΜ͘΋ͻ͔Μ
    ✔ ൺֱతएऀ
    ✔ ൅ͷ৭͕ఆظతʹมΘΔ͜
    ͱʹఆධ͕͋Δ
    ✔ όοΫΤϯυدΓͷٕज़͕
    ޷͖ɻISUCONຖ೥ࢀઓதʂ

    View full-size slide

  3. ΑΖ͓͘͠Ͷ͕͍͠·͢ʂ

    View full-size slide

  4. ΫΠζ࢝ΊΔΑ😈

    View full-size slide

  5. ϧʔϧ
    📙 MySQL όʔδϣϯ = 8.0.31


    👮 ࢖ͬͯྑ͍΋ͷ = ࣗ෼ͷ೴Έͦ (No Google, ChatGPT, etc…)

    View full-size slide

  6. ୈҰ໰.Z42-ͷl.Zzͷ༝དྷʜ

    View full-size slide

  7. ୈҰ໰.Z42-ͷl.Zzͷ༝དྷ͸ڞಉ૑ۀऀ
    ɹɹɹͷ່ͷ໊લ͔Βདྷ͍ͯ·͕͢ɺ
    ɹɹɹ͜ͷΠϧΧͷ໊લ͸ԿͰ͠ΐ͏͔ʁɹ
    ⏰ඵ
    બ୒ࢶ
    "ΧΠϧ

    #αΩʔϥ

    $ϧγϑΝʔ

    View full-size slide

  8. ਖ਼ղ͸ެࣜϦϑΝϨϯεʹ
    هࡌ͕͋Γ·͢

    View full-size slide

  9. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOFOIJTUPSZIUNM

    View full-size slide

  10. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOFOIJTUPSZIUNM

    View full-size slide

  11. ਖ਼ղ͸
    #αΩʔϥ

    View full-size slide

  12. ΫΤϦ
    ୈೋ໰͜ͷΫΤϦͷग़ྗ݁Ռ͸ʁ
    બ୒ࢶ
    4&-&$5/6--/6--
    " 536&


    # '"4-&


    $Ͱ΋Ͱ΋ͳ͍
    ⏰ඵ

    View full-size slide

  13. ૣ଎࣮ߦͯ͠Έ·͠ΐ͏

    View full-size slide

  14. ਖ਼ղ͸
    $Ͱ΋Ͱ΋ͳ͍

    View full-size slide

  15. ΋ͪΖΜެࣜϦϑΝϨϯεʹ
    هࡌ͕͋Γ·͢

    View full-size slide

  16. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOKBQSPCMFNTXJUIOVMMIUNM

    View full-size slide

  17. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOKBQSPCMFNTXJUIOVMMIUNM

    View full-size slide

  18. ୈࡾ໰ ࠷ऴ໰୊

    View full-size slide

  19. ςʔϒϧఆٛ
    ୈࡾ໰͜ͷΫΤϦɺJOEFYޮ͘ʁ
    ΫΤϦ
    $3&"5&5"#-&UXJUUFS@BDDPVOUT
    JE7"3$)"3
    /05/6--
    OBNF7"3$)"3
    /05/6--
    13*."3:,&: AJEA

    ,&: OBNF



    4&-&$5
    '30.UXJUUFS@BDDPVOUT
    8)&3&JE
    ⏰ඵ

    View full-size slide

  20. ΧϥϜͷܕͱ8)&3&Ͱ༩͑ͯ
    ͍Δ஋ͷܕΛྑ͘ݟ·͠ΐ͏

    View full-size slide

  21. ςʔϒϧఆٛ
    ୈೋ໰͜ͷΫΤϦɺJOEFYޮ͘ʁ
    ΫΤϦ
    $3&"5&5"#-&UXJUUFS@BDDPVOUT
    JE7"3$)"3
    /05/6--
    OBNF7"3$)"3
    /05/6--
    13*."3:,&: AJEA



    4&-&$5
    '30.UXJUUFS@BDDPVOUT
    8)&3&JE

    View full-size slide

  22. &YQMBJOͯ֬͠ೝ͠·͢

    View full-size slide

  23. ΋ͪΖΜ΋ͪΖΜɺ
    ެࣜϦϑΝϨϯεʹهࡌ͕͋Γ·͢

    View full-size slide

  24. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOFOUZQFDPOWFSTJPOIUNM

    View full-size slide

  25. ͪͳΈʹ
    ͜ͷ໰୊Λ$IBU(15ʹग़ͨ͠Βʜ
    (15 (15

    View full-size slide

  26. ͪΌΜͱυΩϡϝϯτΛಡΜͰ
    ྑ͍.Z42-ϥΠϑΛ🤗

    View full-size slide