Share
Embed
Transcript
63 slides
-
ࢦͤͭΠϯσοΫε MySQL 5.6 ͷ InnoDB ͷ͓Ͱ͢ɻ 2015/11/14 Yokohama North Meetup
ˌ1 #yokohama_north -
# • # Ͱ࣮ࡍʹඞཁͳશ ͯ༿ϊʔυʹ֨ೲ͞ΕΔ • ϧʔτͱ༿ͷؒͷϊʔυࢠϊʔ υͷϙΠϯλΛ࣋ͭ •
શͯͷ༿ϊʔυϧʔτ͔Β ڑʹ͋Δ • *OOP%#Ͱɺ༿ϊʔυʹओΩʔ ͷΛ֨ೲ͢Δʢޙड़ʣ ը૾Ҿ༻ݩ8JLJQFEJB IUUQTKBXJLJQFEJBPSHXJLJ## &$" -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ 6TFSTςʔϒϧ LFZ OBNF BEESFTT BHF -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' AND address = 'Tokyo' AND age = 33 SELECT * FROM users ORDER BY name, address, age -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' AND address = 'Tokyo' AND age = 33 SELECT * FROM users ORDER BY name, address, age ΠϯσοΫεͷશͯͷྻΛࢦఆ͍ͯ͠ΔͷͰޮ͘ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND address = 'Okayama' SELECT * FROM users ORDER BY name, address -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND address = 'Okayama' SELECT * FROM users ORDER BY name, address ΠϯσοΫεͷࠨ͔Βͷྻ͕ࢦఆ͞Ε͍ͯΔͷͰޮ͘ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE address = 'Okayama' AND age = 58 -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE address = 'Okayama' AND age = 58 ΠϯσοΫεͷࠨͷྻ͕ࢦఆ͞Εͯͳ͍ͷͰޮ͔ͳ͍ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND age = 58 -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND age = 58 ΠϯσοΫεͷྻ͕εΩοϓ͞Ε͍ͯΔͨΊࠨͷྻͷΈ͕ޮ͘ .PSJUB͞ΜશͯͷߦΛಡΈࠐΉඞཁ͕͋Δ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name LIKE 'M%' SELECT * FROM users WHERE name > 'Endo' -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name LIKE 'M%' SELECT * FROM users WHERE name > 'Endo' ൣғͷݕࡧͰΠϯσοΫεޮ͘ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' AND address like 'T%' -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' AND address like 'T%' ͋ΔྻͷશҰகͱผͷྻͷൣғݕࡧͰޮ͘ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND address LIKE 'O%' AND age = 58 -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND address LIKE 'O%' AND age = 58 ൣғݕࡧͰΘΕͨྻΑΓӈଆͷྻޮ͔ͳ͍ 0`Ͱ࢝·ΔॅॴʹॅΉ`.PSJUB`͞ΜͷߦΛશͯऔಘ͢Δඞཁ͕͋Δ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND address IN ('Okinawa', 'Osaka') AND age = 58 -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Morita' AND address IN ('Okinawa', 'Osaka') AND age = 58 -*,&Λ*/ʹॻ͖͢͜ͱ͕Ͱ͖Εޮ͘ -
ΫϥελԽΠϯσο Ϋε • ΫϥελԽΠϯσοΫεɺΠ ϯσοΫεͷछྨͷ໊લͰͳ ͍ • ༿ϊʔυͷʹɺߦࣗମ͕֨ೲ ͞Ε͍ͯΔΠϯσοΫεͷ͜ͱ •
*OOP%#ओΩʔͰΫϥελԽ ΠϯσοΫεΛͭ͘Δ • ओΩʔ͕ྡͷߦɺσΟεΫ্ ͰฒΜͰ͍ΔՄೳੑ͕ߴ͍ ߦ ߦ ߦ ߦ -
ΫϥελԽΠϯσοΫεͷҙ • ΫϥελԽʹΑΓۙ͘ʹฒΜͩσʔλΛऔಘ͢Δͱ͖ʹ*0ΛݮΒ͢͜ͱ͕Ͱ ͖Δɻͦͦશͯͷσʔλ͕ϝϞϦʹऩ·Δ߹ͦΕ΄ͲޮՌతͰͳ͍ • ओΩʔͷॱংͰૠೖ͢Δͷ͕࠷ޮత͕ͩɺओΩʔͷॱংҎ֎Ͱૠೖ͞Ε Δͱϖʔδׂ͕ى͖ΔՄೳੑ͕͋ΓඇޮʹͳΔ • ओΩʔҎ֎ͷΠϯσοΫεΛ͏ͱ͖ΠϯσοΫεͷ୳ࡧ͕ճʹͳΔ ओΩʔ
ओΩʔ ओΩʔ ओΩʔ ηΧϯμϦ ΠϯσοΫε ߦ ߦ ߦ ߦ ओΩʔͷ ΠϯσοΫε ʢΫϥελԽʣ -
8)&3&۟ • 4&-&$5 '30.UBCMF8)&3&DPM"/%DPM • ओΩʔ͕DPMɺηΧϯμϦΠϯσοΫε͕ͳ͍߹ɺΫϥελԽΠϯσο ΫεͷશͯͷϦʔϑΛσΟεΫͷϒϩοΫʢϖʔδʣ͔ΒϝϞϦʹಡΈࠐ Ή • ϝϞϦʹಡΈࠐΜͰ͔ΒɺDPMΛຬͨ͢ߦ͚ͩΛฦ͢
• σʔλ͕ଟ͍߹ɺଟͷϖʔδΛಡΈඞཁ͕͋ΔͨΊɺ*0͕ͨ͘͞Μൃ ੜ͢Δ • σΟεΫ*0ɺγʔΫճస͕ͪൃੜ͢ΔͨΊɺͱ͍ͯʂ -
• 4&-&$5 '30.UBCMF8)&3&DPM"/%DPM • ओΩʔ͕DPMɺDPͷηΧϯμϦΠϯσοΫε͕͋Δ߹ɺηΧϯμ ϦΠϯσοΫεΛ͍ɺDPMΛຬͨ͢ϦʔϑΛऔಘ͢Δ • ͜ͷ࣌ɺDPMॱ൪ʹฒΜͰ͍ΔͨΊɺඞཁͳϦʔϑ͕ಉҰϖʔδʹ ͋ΔՄೳੑ͕ߴ͘ɺಡΉϖʔδ͕ݮΓɺ*0ͦ͜·Ͱ૿͑ͳ͍ʢՄ ೳੑ͕ߴ͍ʣ
• ࣍ʹɺηΧϯμϦΠϯσοΫε͔Βऔಘͨ͠Ϧʔϑ͔ΒಘΒΕΔओΩʔ ΛͬͯɺΫϥελԽΠϯσοΫε͔ΒߦΛಡΈࠐΉ • ߦओΩʔͷॱ൪ͰฒΜͰ͍Δͷ͕ɺηΧϯμϦΠϯσοΫε͔Βऔ ಘͨ͠ओΩʔ͕ॱ൪ʹฒΜͰ͍ΔͱݶΒͳ͍ͨΊɺෳͷϖʔδΛ ಡΉඞཁ͕͋ΔϥϯμϜ*0 • ηΧϯμϦΠϯσοΫεͰओΩʔ͕ߜΕͯͳ͍ͱ*0͕ଟ͍ʂʢߦ ͕গͳ͍߹ϑϧεΩϟϯͷํ͕͍Մೳੑ͋Γʣ -
03%&3#:۟ • 4&-&$5 '30.UBCMF8)&3&03%&3#:DPM%&4$-*.*5 • ओΩʔ͕DPMɺηΧϯμϦΠϯσοΫε͕ͳ͍߹ɺΫϥελԽΠϯσο ΫεͷશͯͷϦʔϑΛσΟεΫͷϒϩοΫʢϖʔδʣ͔ΒϝϞϦʹಡΈࠐ Ή • ϝϞϦʹಡΈࠐΜͰ͔ΒɺDPMͷ߱ॱͰιʔτͯ݅͠ฦ͢
• σʔλ͕ଟ͍߹ɺଟͷϖʔδΛಡΈඞཁ͕͋ΔͨΊɺ*0͕ͨ͘͞Μൃ ੜ͢Δ -
• 'JMFTPSUΛڐ༰͠ͳ͍ͱ͢ΔͱɺΫΤϦͱΠϯσοΫεͷઃܭ੍͕ݶ͞ ΕΔ • ͭͷΠϯσοΫεͰ8)&3&۟ͱ03%&3#:۟ͰඞཁͳྻΛΧόʔ͢ Δඞཁ͕͋Δ • 8)&3&۟Λ༏ઌ͢Δ͔ɺ03%&3#:۟Λ༏ઌ͢Δ͔ɺσʔλͱΫΤϦ ͷಛੑΛݟͯΑ͘ݕ౼͢Δඞཁ͕͋Δ ˞8)&3&۟Ͱඞཁͳߦ͕ߦͱ͔ʹߜΓࠐ·ΕΔͷͰ͋Εɺߦ
Λऔಘ͔ͯ͠Βιʔτͯ͠ͳ͍ ˞ߦΛऔಘ͔ͯ͠Β8)&3&۟ͷߜΓࠐΈΛ͢Δ߹ɺ&YQMBJOͷ&YUSB ྻʹ6TJOHXIFSFͱදࣔ͞ΕΔ • 8IFSFૂ͍ͷΩʔɺPSEFSCZૂ͍ͷΩʔ IUUQXXXTMJEFTIBSFOFUZPLVXIFSFPSEFSCZ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ 6TFSTςʔϒϧ LFZ OBNF BEESFTT BHF -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY address -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY address ΠϯσοΫεͷྻΛࠨ͔Βॱ൪ʹࢦఆ͍ͯ͠ΔͷͰޮ͘ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY address, age -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY address, age ΠϯσοΫεͷྻΛࠨ͔Βॱ൪ʹࢦఆ͍ͯ͠ΔͷͰޮ͘ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users ORDER BY address -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users ORDER BY address ΠϯσοΫεͷྻΛεΩοϓ͍ͯ͠ΔͷͰޮ͔ͳ͍ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY address DESC -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY address DESC ΠϯσοΫεͷྻશͯঢॱͳͷͰޮ͘ͷOBNFͰͷߜΓࠐΈ·Ͱ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY age -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' ORDER BY age ΠϯσοΫεͷྻΛεΩοϓ͍ͯ͠ΔͷͰޮ͘ͷOBNFͰͷߜΓࠐΈ·Ͱ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' address LIKE ’T%' ORDER BY address, age -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' address LIKE ’T%' ORDER BY address, age ൣғݕࡧͰͬͨྻΑΓޙΖͷྻ͑ͳ͍ͷͰޮ͘ͷBEESFTTͰͷߜΓࠐΈ·Ͱ -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' address IN ('Tokyo', 'Tokushima') ORDER BY address, age -
Sato Aomori 32 Nakamura Kyoto 39 Aoki Hokkaido 19 Baba
Ishikawa 65 Endo Chiba 24 Endo Chiba 24 Endo Tokyo 33 Dobashi Nigata 30 Morita Okayama 58 Yamada Kanagawa 39 Nakamura Kyoto 39 Okada Shizuoka 15 ɾɾɾ ɾɾɾ ɾɾɾ ɾɾɾ SELECT * FROM users WHERE name = 'Endo' address IN ('Tokyo', 'Tokushima') ORDER BY address, age ιʔτͷ߹*/۟ͰมΘΒͣɺޮ͘ͷBEESFTTͰͷߜΓࠐΈ·Ͱ -
+0*/ 03%&3#: • 4&-&$5DPM'30.U*//&3+0*/U0/UDPMUDPM8)&3& UDPM03%&3#:UDPM • +0*/ͯ͠ɺUBCMFͷΧϥϜΛ8)&3&۟ͰɺUBCMFͷΧϥϜΛ03%&3#: ۟Ͱ༻͍ͯ͠Δ߹ɺ6TJOHUFNQPSBSZ6TJOHpMFTPSUʹͳͬͯ͠·͏ •
Φτί ͷίϯϐϡʔλಓ6TJOHpMFTPSU IUUQOJQQPOEBOKJCMPHTQPUKQVTJOHpMFTPSUIUNM -
• ΧόϦϯάΠϯσοΫεΛ͑ߦΛऔಘ͢Δඞཁ͕ͳ͘ͳΓɺओΩʔ ͷΠϯσοΫεΛ୳ࡧ͢Δඞཁͳ͘ͳΔ • ϥϯμϜ*0͕ͳ͘ͳΔʂ ओΩʔ ओΩʔ ओΩʔ ओΩʔ ηΧϯμϦ
ΠϯσοΫε ߦ ߦ ߦ ߦ ओΩʔͷ ΠϯσοΫε ʢΫϥελԽʣ ηΧϯμϦΠϯσο Ϋε͚ͩͰ݁ ओΩʔͷΠϯσοΫ εΛݟΔඞཁͳ͠ -
Ԇ݁߹ • ΠϯσοΫεʹؚ·Ε͍ͯͳ͍ྻ͕͋ΔͨΊߦΛऔಘ͢Δඞཁ͕͋Δ • ߦΛऔಘ͔ͯ͠Β0''4&5 -*.*5ʹΑ͍ͬͯΒͳ͍ߦ͕ࣺͯΒΕΔ SELECT name, introduction FROM
users ORDER BY name, address LIMIT 100, 10 SELECT name, introduction FROM users t1 INNER JOIN ( SELECT id FROM users ORDER BY name, address LIMIT 100, 10 ) t2 ON t1.id = t2.id • ΧόϦϯάΠϯσοΫεͰ݅ʹߜΓࠐΜͰ͔ΒߦΛऔಘ͢Δ • ߦΛऔಘ͢ΔલʹඞཁͳߦΛ0''4&5 -*.*5ͰߜΓࠐΊΔ -
ͭΠϯσοΫε • ߦ͕ΫΤϦͰඞཁͳॱংʹฒΜͰ͍Δ ΠϯσοΫε͕ඞཁͳॱংͰฒΜͰ͍Δ߹ɺߦΛऔಘ͔ͯ͠Βιʔτ ͢ΔॲཧΛආ͚Δ͜ͱ͕Ͱ͖Δ • ΠϯσοΫεΛऔಘ͍ͨ͠ॱ൪ʹฒ͓ͯ͘ʢ6TJOHpMFTPSUΛආ͚Δʣ • ͭͷΠϯσοΫεͰ8)&3&۟ͱ03%&3#:۟ΛΧόʔ •
ͦΕ͕͍͠߹ɺ8)&3&۟ʹΑΔߜΓࠐΈΛॏࢹ͢Δ͔ɺ6TJOH pMFTPSUΛආ͚Δ͔ɺͲͪΒΛ༏ઌ͢Δ͔Λݕ౼͢Δ͜ͱ -
ࢀߟ • ࣮ફϋΠύϑΥʔϚϯε.Z42-ୈ൛ IUUQXXXBNB[PODPKQ࣮ફϋΠύϑΥʔϚϯε.Z42-ୈ൛#BSPO 4DIXBSU[EQ • 8IFSFૂ͍ͷΩʔɺPSEFSCZૂ͍ͷΩʔ IUUQXXXTMJEFTIBSFOFUZPLVXIFSFPSEFSCZ •
Φτί ͷίϯϐϡʔλಓ6TJOHpMFTPSU IUUQOJQQPOEBOKJCMPHTQPUKQVTJOHpMFTPSUIUNM