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

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

MySQLクイズ for テテミート #2 / MySQL Quiz for 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 Slide

  2. View Slide

  3. XIPBNJ

    View Slide

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

    View Slide

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

    View Slide

  6. View Slide

  7. ΫΠζ࢝ΊΔΑ😈

    View Slide

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


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

    View Slide

  9. View Slide

  10. ୈҰ໰

    View Slide

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

    View Slide

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

    #αΩʔϥ

    $ϧγϑΝʔ

    View Slide

  13. 5*.&61

    View Slide

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

    View Slide

  15. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOFOIJTUPSZIUNM

    View Slide

  16. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOFOIJTUPSZIUNM

    View Slide

  17. ਖ਼ղ͸
    #αΩʔϥ

    View Slide

  18. View Slide

  19. ୈೋ໰

    View Slide

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


    # '"4-&


    $Ͱ΋Ͱ΋ͳ͍
    ⏰ඵ

    View Slide

  21. 5*.&61

    View Slide

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

    View Slide

  23. View Slide

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

    View Slide

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

    View Slide

  26. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOKBQSPCMFNTXJUIOVMMIUNM

    View Slide

  27. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOKBQSPCMFNTXJUIOVMMIUNM

    View Slide

  28. View Slide

  29. ୈࡾ໰ ࠷ऴ໰୊

    View Slide

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

    ,&: OBNF



    4&-&$5
    '[email protected]
    8)&3&JE
    ⏰ඵ

    View Slide

  31. 5*.&61

    View Slide

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

    View Slide

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



    4&-&$5
    '[email protected]
    8)&3&JE

    View Slide

  34. &YQMBJOͯ֬͠ೝ͠·͢

    View Slide

  35. View Slide

  36. ਖ਼ղ͸

    View Slide

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

    View Slide

  38. 4FFIUUQTEFWNZTRMDPNEPDSFGNBOFOUZQFDPOWFSTJPOIUNM

    View Slide

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

    View Slide

  40. View Slide

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

    View Slide