データベースについて

Transcript

1. Database Ishikami Naotaka
2. ɾϓϩάϥϛϯάྺ໿20೥ͷWebΤϯδχΞ ɾཱྀߦɺϘʔυήʔϜ͕޷͖Ͱ͢ɻ ੴ্௚޹ @dorarep 2 ϕτφϜϥϘ΍ࢠձࣾ૑ઃ αϯςΟΞΰ८ྱ Magic the Gathering খֶੜͷࠒ͔ΒήʔϜ࡞Γ
3. ࠓ೔ͷΰʔϧ جૅతͳ஌ࣝ Λཧղ͢Δ͜ͱͰ ௐ΂ͳ͕Β Ͱྑ͍ͷͰ σʔλϕʔεΛ ࢖͑Δ Α͏ʹͳΔ͜ͱ 3 ҉ه ͢ΔΑΓ ཧղ ͠Α͏ʂ
4. 1. Database֓࿦ ·ͣ͸શମײΛ೺Ѳ͠·͠ΐ͏ 4
5. DB ( Database ) ͱ͸ʁ 5 σʔλΛѻ͍΍͍͢ܗͰೖΕ͓ͯ͘ശͰ͢
6. DB ( Database ) ͱ͸ʁ 6 σʔλΛѻ͍΍͍͢ܗͰೖΕ͓ͯ͘ശͰ͢ name lv hp mp ͋Δ͢ 35 79 0 ͜ͳΜ 33 140 63 ͤΓ͋ 27 151 67 ༐ऀσʔλ
7. DBMS ( DatabaseManagementSystem ) ͱ͸ʁ 7 ͦͷശΛ؅ཧ͢ΔγεςϜͰ͢
8. DBMS ( DatabaseManagementSystem ) ͱ͸ʁ ͦͷശΛ؅ཧ͢ΔγεςϜͰ͢ 8 DBMS ϩάΠϯ͍ͨ͠Έ͍ͨͩɻ Ϣʔβσʔλ͘Εʂ ͸͍Αʂ DB
9. Question ࣗ෼ͰσʔλΛ؅ཧͨ͠ΒͲ͏ͳͷʁ 9 file = File.open("access.txt", "r") count = file.gets.to_i + 1 file.close file = File.open("access.txt", "w") file.puts(count) file.close load save count count + 1 ΞΫηε਺.txt ΞΫηεΧ΢ϯλʔ
10. Answer 10 ͜ͷྫͷ৔߹ɺಉ࣌ΞΫηεͨ͠ͱ͖ʹยํͷ஋͕൓ө ͞Εͳ͍͜ͱ͕͋Γ·͢ɻ 10 10 + 1 10 10 10 + 1 11
11. Answer 11 ͜ͷྫͷ৔߹ɺಉ࣌ΞΫηεͨ͠ͱ͖ʹยํͷ஋͕൓ө ͞Εͳ͍͜ͱ͕͋Γ·͢ɻ 10 10 + 1 10 10 10 + 1 11 DBMSΛ࢖Θͳ͚Ε͹࡞Εͳ͍༁Ͱ͸ͳ͍ ༷ͨͩʑͳศརͳػೳ͕͋ΔͨΊ ΈΜͳ࢖͍ͬͯ·͢ʂ
12. DBMSͷछྨ 12 DBMS RDBMS NoSQL . . . . ͘͘͝͝Ұ෦
13. DBMSͷछྨ 13 DBMS RDBMS NoSQL . . . . ͘͘͝͝Ұ෦ SQLΛ࢖͍දͷܗࣜͷσʔλΛѻ͏΋ͷ RDBMSҎ֎ͷDBMS
14. DBMSͷछྨ 14 DBMS RDBMS NoSQL . . . . ͘͘͝͝Ұ෦ SQLΛ࢖͍දͷܗࣜͷσʔλΛѻ͏΋ͷ RDBMSҎ֎ͷDBMS RDBMS͕جຊͰ͢ɻ ࣮ࡍʹ৮ֶͬͯΜͰ͍͖·͠ΐ͏ʂ
15. 2. ४උ MySQLΛ࢖͏४උΛ͠·͠ΐ͏ 15
16. ͱ͸ʁ 16 ΦʔϓϯιʔεͷRDBMSͰ ੈքͰ΋ͬͱ΋࢖ΘΕ͍ͯΔ΋ͷͰ͢ ઃܭਤ͕ެ։͞Ε͍ͯͯ ࣗ༝ʹ࢖͑Δ΋ͷ
17. MySQLͷInstallɾىಈ 17 $ /usr/bin/ruby -e "$(curl -fsSL https:// raw.githubusercontent.com/Homebrew/ install/master/install)" $ brew install mysql $ brew services start mysql mac
18. MySQLͷInstallɾىಈ 18 $ brew install mysql $ brew services start mysql mac 3306൪ ϙʔτ ϩάΠϯ͍ͨ͠Έ͍ͨͩɻ Ϣʔβσʔλ͘Εʂ
19. RDBMSͱͷʮ஻Γํʯ 19
20. RDBMSͱͷʮ஻Γํʯ 20 RDBMSͱ͸ SQLͱ͍͏ݴ༿Λ࢖ͬͯ஻Γ·͢
21. RDBMSͱͷʮ஻Γํʯ 21 3306൪ ϙʔτ ϩάΠϯ͍ͨ͠Έ͍ͨͩɻ Ϣʔβσʔλ͘Εʂ RDBMSͱ͸ SQLͱ͍͏ݴ༿Λ࢖ͬͯ஻Γ·͢
22. RDBMSͱͷʮ஻Γํʯ 22 3306൪ ϙʔτ SELECT * FROM users WHERE id = 1 RDBMSͱ͸ SQLͱ͍͏ݴ༿Λ࢖ͬͯ஻Γ·͢
23. Try ࣮ࡍʹSQLจΛଧͬͯΈΑ͏ 23 $ mysql -uroot ... mysql> select version(); +-----------+ | version() | +-----------+ | 5.7.22 | +-----------+ 1 row in set (0.00 sec) MySQLͱͷʮର࿩ϞʔυʯʹೖΔίϚϯυ όʔδϣϯΛਘͶΔSQLจ
24. GUIπʔϧΛ࢖ͬͯΈΑ͏ʂ 24 શମ૾͕෼͔ΓͮΒ͍... ຖճίϚϯυଧͭͷ͠ΜͲ͍...
25. GUIπʔϧΛ࢖ͬͯΈΑ͏ʂ 25 શମ૾͕෼͔ΓͮΒ͍... ຖճίϚϯυଧͭͷ͠ΜͲ͍... Θ͔Γ΍͍͢ʂ
26. GUIπʔϧΛ࢖ͬͯΈΑ͏ʂ 26 શମ૾͕෼͔ΓͮΒ͍... ຖճίϚϯυଧͭͷ͠ΜͲ͍... Θ͔Γ΍͍͢ʂ (஫ҙ) ૝ఆ֎ͷෛՙ͕͔͔ΔՄೳੑ͕͋ΔͨΊ ࣮຿Ͱຊ൪DBΛπʔϧͰ৮Δͷ͸ ඇਪ঑Ͱ͢
27. ΦεεϝͷGUIπʔϧ 27 mac windows Sequel Pro https://www.sequelpro.com/ MySQL Workbench https://www.mysql.com/jp/products/workbench/
28. GUIπʔϧͷઃఆ 28
29. GUIπʔϧ্͔ΒSQLจΛଧͭ͜ͱ΋Ͱ͖·͢ 29
30. 3-1. ࣮ફ1 ςʔϒϧ σʔλΛೖΕΔശΛ࡞ͬͯΈΑ͏ʂ 30
31. ώʔϩʔͱఢ͕ઓ͏RPGήʔϜΛ࡞Δ૝ఆͰ ࣮ફͯ͠Έ·͠ΐ͏ʂ RPGͷઓಆγεςϜΛ࡞Δ͜ͱʹͳΓ·ͨ͠ 31
32. Question ͲΜͳදͰώʔϩʔͱఢΛදݱͰ͖Δ͔ ߟ͑ͯΈΑ͏ 32 ࢓༷ ώʔϩʔͱఢ͸໊લͱHPͱ߈ܸྗΛ࣋ͪ·͢ɻ
33. Answerྫ 33 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ώʔϩʔͷද ఢͷද ࢓༷ ώʔϩʔͱఢ͸໊લͱHPͱ߈ܸྗΛ࣋ͪ·͢ɻ
34. ࣮ࡍʹσʔλϕʔε͸Ͳ͏ͳ͍ͬͯΔͷ͔ʁ 34 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ώʔϩʔςʔϒϧ ఢςʔϒϧ RPGσʔλϕʔε ϑΟʔϧυ (ྻɾΧϥϜ) Ϩίʔυ(ߦ)
35. ϑΟʔϧυͷܕ 35 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ֤ϑΟʔϧυʹͲΜͳ஋͕ೖΔ͔Λ ʮܕʯͰࢦఆ͠·͢ ਺஋ ਺஋ ਺஋ ਺஋ จࣈ จࣈ
36. ϑΟʔϧυͷܕ 36 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ֤ϑΟʔϧυʹͲΜͳ஋͕ೖΔ͔Λ ʮܕʯͰࢦఆ͠·͢ ਺஋ ਺஋ ਺஋ ਺஋ จࣈ จࣈ σʔλϕʔεʹ૝ఆ֎ͷ஋͕ೖΔͷΛ๷͙
37. ϑΟʔϧυͷܕ 37 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ֤ϑΟʔϧυʹͲΜͳ஋͕ೖΔ͔Λ ʮܕʯͰࢦఆ͠·͢ ਺஋ ਺஋ ਺஋ ਺஋ จࣈ จࣈ σʔλϕʔεʹ૝ఆ֎ͷ஋͕ೖΔͷΛ๷͙ σʔλྔΛ૝ఆͯ͠ശΛ༻ҙ͢Δ͜ͱͰແବΛݮΒ͢
38. ϑΟʔϧυͷܕ 38 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ֤ϑΟʔϧυʹͲΜͳ஋͕ೖΔ͔Λ ʮܕʯͰࢦఆ͠·͢ ਺஋ ਺஋ ਺஋ ਺஋ จࣈ INT ੔਺ VARCHAR จࣈྻ (࠷େจࣈ਺͋Γ) DATE ೔෇ ୅දతͳʮܕʯ จࣈ
39. ϑΟʔϧυͷܕ 39 ໊લ HP ߈ܸྗ ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 ໊લ HP ߈ܸྗ ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 ֤ϑΟʔϧυʹͲΜͳ஋͕ೖΔ͔Λ ʮܕʯͰࢦఆ͠·͢ int int int int varchar (50) INT ੔਺ VARCHAR จࣈྻ (࠷େจࣈ਺͋Γ) DATE ೔෇ ୅දతͳʮܕʯ varchar (50)
40. Try ࣮ࡍʹDBΛ࡞ͬͯΈΑ͏ʂ 40 40 name(int) hp(int) power(int) ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 name(varchar) hp(int) power(int) ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 heroes table enemies table db: rpg CREATE DATABASE rpg; USE rpg; CREATE TABLE heroes ( name VARCHAR(50), hp INT, power INT ); CREATE TABLE enemies ( name VARCHAR(50), hp INT, power INT );
41. 3-2. ࣮ફ2 Ϩίʔυૢ࡞ SQLͰϨίʔυૢ࡞ͯ͠ΈΑ͏ʂ 41
42. ϨίʔυΛૢ࡞͢ΔSQLจɹʔɹ௥ՃʢINSERTʣ INSERT INTO ςʔϒϧ໊ ( ϑΟʔϧυ໊ ) VALUES ( ೖΕΔ஋ ) name(varchar) hp(int) power(int) ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 heroes table ྫ
43. Try herosͱenemiesʹϨίʔυΛೖΕͯΈΑ ͏ʂ 43 43 name(int) hp(int) power(int) ΰϒϦϯ 20 20 εϥΠϜ 30 10 ຐԦͷ࢖͍ 50 50 name(varchar) hp(int) power(int) ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 heroes table enemies table db: rpg INSERT INTO ςʔϒϧ໊ ( ϑΟʔϧυ໊ ) VALUES ೖΕΔ஋
44. ϨίʔυΛૢ࡞͢ΔSQLจɹʔɹऔಘʢSELECTʣ SELECT औͬͯ͘ΔϑΟʔϧυ FROM ςʔϒϧ໊ WHERE औಘ৚݅ ྫ
45. ϨίʔυΛૢ࡞͢ΔSQLจɹʔɹऔಘʢSELECTʣ SELECT औͬͯ͘ΔϑΟʔϧυ FROM ςʔϒϧ໊ WHERE औಘ৚݅ ྫ ถҹʢ*ʣͰશͯऔͬͯ͘Δɻ ΧϯϚ۠੾Γʢ,ʣͰෳ਺ࢦఆɻ
46. ϨίʔυΛૢ࡞͢ΔSQLจɹʔɹऔಘʢSELECTʣ SELECT औͬͯ͘ΔϑΟʔϧυ FROM ςʔϒϧ໊ WHERE औಘ৚݅ ྫ AND΍ORͰ৚݅Λܨ͛Δ͜ͱͰෳ਺ࢦఆɻ
47. Try ৭ʑͳϨίʔυΛऔ͖ͬͯͯΈΑ͏ʂ 47 47 ɾheroesͷϨίʔυશͯ ɾhp͕25Ҏ্ͷenemiesͷname ɾhp͕25Ҏ্Ͱpower͕30ҎԼͷenemiesͷhpͱpower SELECT औͬͯ͘ΔϑΟʔϧυ FROM ςʔϒϧ໊ WHERE औಘ৚݅
48. ϨίʔυΛૢ࡞͢ΔSQLจɹʔɹߋ৽ʢUPDATEʣ UPDATE ςʔϒϧ໊ SET ஋ WHERE มߋ͢ΔϨίʔυͷ৚݅ ྫ
49. Try ৭ʑͳϨίʔυΛมߋͯ͠ΈΑ͏ʂ 49 49 ɾ໊લ͕ʮ༐ऀʯͷheroesͷpowerΛ100ʹ͢Δ ɾશͯͷheroesͷpowerͱhpΛ20ʹ͢Δ UPDATE ςʔϒϧ໊ SET ஋ WHERE มߋ͢ΔϨίʔυͷ৚݅
50. ϨίʔυΛૢ࡞͢ΔSQLจɹʔɹ࡟আʢDELETEʣ DELETE FROM ςʔϒϧ໊ WHERE ࡟আ͢ΔϨίʔυͷ৚݅ ྫ
51. Try ৭ʑͳϨίʔυΛ࡟আͯ͠ΈΑ͏ʂ 51 51 ɾ໊લ͕ʮ༐ऀʯ͔ʮૐཿʯͷϨίʔυΛheroes͔Β࡟আ͢Δ ɾhp͕20Ͱpower͕20ͷϨίʔυΛenemies͔Β࡟আ͢Δ DELETE FROM ςʔϒϧ໊ WHERE ࡟আ͢ΔϨίʔυͷ৚݅
52. 3-3. ࣮ફ3 ϦϨʔγϣϯ දͱදͷؔ܎ੑΛදݱͯ͠ΈΑ͏ʂ 52
53. Question Ͳ͏΍ͬͨΒ࣮ݱͰ͖Δ͔૝૾ͯ͠ΈΑ͏ 53 ࢓༷ ༐ऀ͸෢ثΛ1ͭ૷උͰ͖ΔΑ͏ʹ͍ͨ͠Ͱ͢ɻ ෢ث͸໊લͱ߈ܸྗΛ࣋ͪ·͢ɻ ʮ͘ͳ͍ʯ͸߈ܸྗ͕2Ͱ͢ɻ ʮ΍Γʯ͸߈ܸྗ͕5Ͱ͢ɻ
54. 54 ࢓༷ ༐ऀ͸෢ثΛ1ͭ૷උͰ͖ΔΑ͏ʹ͍ͨ͠Ͱ͢ɻ ෢ث͸໊લͱ߈ܸྗΛ࣋ͪ·͢ɻ ʮ͘ͳ͍ʯ͸߈ܸྗ͕2Ͱ͢ɻ ʮ΍Γʯ͸߈ܸྗ͕5Ͱ͢ɻ 54 name(varchar) hp(int) power(int) weapon_name weapon_power ༐ऀ 100 20 ΍Γ 5 ઓ࢜ 50 50 ΍Γ 5 ૐཿ 200 10 ͘ͳ͍ 2 heroes table
55. 55 ࢓༷ ༐ऀ͸෢ثΛ1ͭ૷උͰ͖ΔΑ͏ʹ͍ͨ͠Ͱ͢ɻ ෢ث͸໊લͱ߈ܸྗΛ࣋ͪ·͢ɻ ʮ͘ͳ͍ʯ͸߈ܸྗ͕2Ͱ͢ɻ ʮ΍Γʯ͸߈ܸྗ͕5Ͱ͢ɻ 55 name(varchar) hp(int) power(int) weapon_name weapon_power ༐ऀ 100 20 ΍Γ 5 ઓ࢜ 50 50 ΍Γ 5 ૐཿ 200 10 ͘ͳ͍ 2 heroes table ಉ͡ʮ಺༰ʯ͕ॏෳͯ͠͠·͍ σʔλͷແବ͕ଟ͍ʂ
56. 56 ࢓༷ ༐ऀ͸෢ثΛ1ͭ૷උͰ͖ΔΑ͏ʹ͍ͨ͠Ͱ͢ɻ ෢ث͸໊લͱ߈ܸྗΛ࣋ͪ·͢ɻ ʮ͘ͳ͍ʯ͸߈ܸྗ͕2Ͱ͢ɻ ʮ΍Γʯ͸߈ܸྗ͕10Ͱ͢ɻ 56 name(varchar) hp(int) power(int) weapon_name weapon_power ༐ऀ 100 20 ΍Γ 5 ઓ࢜ 50 50 ΍Γ 5 ૐཿ 200 10 ͘ͳ͍ 2 heroes table ࢓༷มߋ͓ئ͍͠·ʔ͢
57. 57 ࢓༷ ༐ऀ͸෢ثΛ1ͭ૷උͰ͖ΔΑ͏ʹ͍ͨ͠Ͱ͢ɻ ෢ث͸໊લͱ߈ܸྗΛ࣋ͪ·͢ɻ ʮ͘ͳ͍ʯ͸߈ܸྗ͕2Ͱ͢ɻ ʮ΍Γʯ͸߈ܸྗ͕10Ͱ͢ɻ 57 name(varchar) hp(int) power(int) weapon_name weapon_power ༐ऀ 100 20 ΍Γ 5 ઓ࢜ 50 50 ΍Γ 10 ૐཿ 200 10 ͘ͳ͍ 2 heroes table ࢓༷มߋ͓ئ͍͠·ʔ͢ 1Օॴߋ৽࿙ΕͪΌͬͨʂ
58. 58 ࢓༷ ༐ऀ͸෢ثΛ1ͭ૷උͰ͖ΔΑ͏ʹ͍ͨ͠Ͱ͢ɻ ෢ث͸໊લͱ߈ܸྗΛ࣋ͪ·͢ɻ ʮ͘ͳ͍ʯ͸߈ܸྗ͕2Ͱ͢ɻ ʮ΍Γʯ͸߈ܸྗ͕10Ͱ͢ɻ 58 name(varchar) hp(int) power(int) weapon_name weapon_power ༐ऀ 100 20 ΍Γ 5 ઓ࢜ 50 50 ΍Γ 10 ૐཿ 200 10 ͘ͳ͍ 2 heroes table ࢓༷มߋ͓ئ͍͠·ʔ͢ 1Օॴߋ৽࿙ΕͪΌͬͨʂ σʔλͷॏෳ͕͋Δͱ ӡ༻্৭ʑͱʮπϥ͍ʯͰ͢...
59. ਖ਼نԽͱ͸ʁ 59 σʔλͷॏෳΛͳͨ͘͢Ίͷ ςʔϒϧઃܭͷߟ͑ํ name(varchar) hp(int) power(int) weapon_name weapon_power ༐ऀ 100 20 ΍Γ 5 ઓ࢜ 50 50 ΍Γ 5 ૐཿ 200 10 ͘ͳ͍ 2 heroes table
60. ਖ਼نԽͱ͸ʁ 60 σʔλͷॏෳΛͳͨ͘͢Ίͷ ςʔϒϧઃܭͷߟ͑ํ name(varchar) hp(int) power(int) ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 heroes table name(varchar) power(int) ͘ͳ͍ 2 ΍Γ 5 weapons table ੾ͬͯ
61. Question Ͳ͏΍ͬͨΒςʔϒϧΛܨ͛ΒΕΔ͔ গ͠ߟ͑ͯΈΑ͏ 61 name(varchar) hp(int) power(int) ༐ऀ 100 20 ઓ࢜ 50 50 ૐཿ 200 10 heroes table name(varchar) power(int) ͘ͳ͍ 2 ΍Γ 5 weapons table ܨ͛Δ
62. ςʔϒϧͱςʔϒϧͷܨ͛ํ 62 name(varchar) hp(int) power(int) weapon_id ༐ऀ 100 20 2 ઓ࢜ 50 50 2 ૐཿ 200 10 1 heroes table Id (int) name(varch ar) power(int) 1 ͘ͳ͍ 2 2 ΍Γ 5 weapons table Primary Key (id) Ͱࢦఆ͢Δ͜ͱͰ ςʔϒϧͱςʔϒϧͷؔ܎ੑΛද͢
63. Primary Keyͱ͸ʁ 63 ϨίʔυΛಛఆ͢ΔͨΊͷϑΟʔϧυ Id (int) name(varch ar) power(int) 1 ͘ͳ͍ 2 2 ΍Γ 5 weapons table
64. 64 name(varchar) hp(int) power(int) power ༐ऀ 100 20 5 ઓ࢜ 50 50 5 ૐཿ 200 10 2 heroes table name(varch ar) power(int) ͘ͳ͍ 2 ΍Γ 5 weapons table ΋͠idͰ͸ͳ͘powerͰܨ͛Α͏ͱͨ͠Βʁ ϨίʔυΛಛఆ͢ΔͨΊͷϑΟʔϧυ Primary Keyͱ͸ʁ
65. Question ߟ͑ͯΈΑ͏ 65 ࠓ͸hero͸1ͭͷ෢ث͔͠૷උ͢Δ͜ͱ͕Ͱ͖·ͤΜɻ ෳ਺ͷ෢ثΛ૷උͰ͖ΔΑ͏ʹ͢Δʹ͸Ͳ͏͢Ε͹ྑ͍Ͱ͠ΐ͏͔ʁ name(varchar) hp(int) power(int) weapon_id ༐ऀ 100 20 2 ઓ࢜ 50 50 2 ૐཿ 200 10 1 heroes table Id (int) name(varch ar) power(int) 1 ͘ͳ͍ 2 2 ΍Γ 5 weapons table
66. 1ର1ɹ1ରଟɹଟରଟ 66 name(varchar) hp(int) power(int) weapon_id ༐ऀ 100 20 2 ઓ࢜ 50 50 2 ૐཿ 200 10 1 heroes table Id (int) name(varch ar) power(int) 1 ͘ͳ͍ 2 2 ΍Γ 5 weapons table දͱදͷؔ܎ੑΛ਺ͰݟͯΈ·͠ΐ͏ heroes͔ΒݟΔͱɺweapon͸1ͭ weapons͔ΒݟΔͱɺheros͸ෳ਺
67. 1ର1ɹ1ରଟɹଟରଟ 67 id name(varch ar) hp(int) power(int) 1 ༐ऀ 100 20 2 ઓ࢜ 50 50 3 ૐཿ 200 10 heroes table Id (int) name(varch ar) power(int) 1 ͘ͳ͍ 2 2 ΍Γ 5 weapons table දͱදͷؔ܎ੑΛ਺ͰݟͯΈ·͠ΐ͏ equip table hero_id weapon_id 1 1 1 2 3 1
68. Question ςʔϒϧΛઃܭͯ͠ΈΑ͏ʂ 68 ώʔϩʔ͸ͦΕͧΕΞΠςϜΛෳ਺ݸ࣋ͭ͜ͱ͕Ͱ͖·͢ɻ ΞΠςϜ͸ʮ໊લʯͱʮઆ໌จʯ͕͋Γ·͢ɻ
69. Question ςʔϒϧΛઃܭͯ͠ΈΑ͏ʂ 69 ੜె͸1ਓ1ͭͷҕһձʹೖ͍ͬͯ·͢ɻ 1ͭͷҕһձʹෳ਺ͷੜె͕ॴଐ͍ͯ͠Δ৔߹΋͋Γ·͢ɻ ੜె͸ʮ໊લʯͱʮ೥ྸʯɺҕһձʹ͸ʮ໊લʯ͕͋Γ·͢ɻ
70. Thanks! Any questions? You can find me at: @dorarep @noseld 70