ćčĄĺşĺ ąăŽ yayawowo ă§ăă çć§ă SQL ăćĽé ă使ăă§ăăăăďź äťĺăŻă ăăăźăżăčż˝ĺ ăăăéăŤćŹ ăăăŞăINSERTćăŽä˝żăćšă¨ăăăăăăŽć¸çąăăç´šäť ăăžăă INSERTćăŽä˝żăćšăçżĺžăăă ăăăăăćĺ
ă§ĺŽčĄĺŻč˝ăŞ SQL ćäťăă§č§ŁčŞŹăăžăă ćŻéăĺŽčˇľăăŞăăçżĺžăă ăăďź âťćŹčŞŹćă§ăŻă PostgreSQL 9.6ăĺŠç¨ăăžăă ăăźăăŤăŽćşĺ INSERTćăăăšăżăźăăă ĺşćŹçăŞä˝żăćš č¤ć°ăŹăłăźăăĺćINSERT ĺĽăăźăăŤăŤINSERT ăăăăăŽć¸çą INSERT ăžă¨ă â ă SQL ĺ
Ľéă PostgreSQL é˘éŁč¨äş ăť ăSQLĺ
ĽéăUPDATE ăžă¨ă ăť ăSQLĺ
ĽéăDISTINCT 使ăćš ăť RDBMSă¨DBMSăŤă¤ăăŚăĺĺżč
ĺăă ăť SQLăŽĺşćŹăăžă¨ăă ăť ăRDBMSăPostgreSQLă¤ăłăšăăźăŤăťăłăăłăĺ
Ľé硨 ăăźăăŤăŽćşĺ ăžăăINSERTćăŽč§ŁčŞŹăŤĺ
ĽăĺăŤäťĺ使ăăăźăăŤăä˝ćăăžăă ăăźăăŤăŽĺĺŽçžŠă¨CREATEćăŻäťĽä¸ăŽéăă§ăă â ĺĺŽçžŠ ĺĺ ăăźăżĺ PK animal _no integer â animal_name text animal_breed text skill _no integer skill_name text â SQL ć --ăăźăăŤä˝ćSQLć CREATE TABLE sample_animal ( animal_no integer primary key, animal_name text, animal_breed text, animal_sex text, skill_no integer , skill_name text ); ă§ăŻăăăźăăŤăĺŽćăăžăăăŽă§INSERTćăŽčŞŹćăŤĺ
Ľăăžăă INSERTćăăăšăżăźăăă ĺşćŹçăŞä˝żăćš INSERTćăŽĺşćŹçăŞä˝żăćšă¨ăăŚăăăźăăŤăŤăăźăżăçťé˛ăăćšćłăă誏ćăăžăă ăžăĺăăŤăĺĺăćĺŽăăăăżăźăłă§ăă ďź ć¸ĺźďźĺĺćĺŽćăăżăźăł ďź INSERT INTO ăăźăăŤĺ (ĺĺ1, ĺĺ2,....) VALUES (ĺ¤1, ĺ¤2, ...) ; ăăźăăŤĺďźăăźăżăçťé˛ăăăăăźăăŤĺăč¨čźăă ĺĺďźĺ¤ăčż˝ĺ ăăăĺĺăč¨čźăă ĺ¤ăďźčż˝ĺ ăăăĺ¤ăč¨čźăă ă§ăŻăINSERTćăć¸ăăŚăżăžăăăďź â SQL ć --SQLćďźINSERTăŽĺşćŹ(ĺĺćĺŽćďź INSERT INTO sample_animal (animal_no, animal_name, animal_breed, animal_sex, skill_no, skill_name) VALUES ( 1 , ' çŹ ' , ' ć´çŹ ' , ' 弳 ' , 1 , null ); INSERT INTO sample_animal (animal_no, animal_name, animal_breed, animal_sex, skill_no, skill_name) VALUES ( 2 , ' çŹ ' , ' ć´çŹ ' , ' çˇ ' , 2 , null ); INSERT INTO sample_animal (animal_no, animal_name, animal_breed, animal_sex, skill_no, skill_name) VALUES ( 3 , ' çŹ ' , ' ăăŻăŻ ' , ' çˇ ' , 1 , null ); âĺŽčĄçľć animal _no animal_name animal_breed animal_sex skill _no skill_name 1 çŹ ć´çŹ ĺĽł 1 (null) 2 çŹ ć´çŹ çˇ 2 (null) 3 çŹ ăăŻăŻ çˇ 1 (null) ăŞăăä¸č¨ SQL ćă§ăŻĺĺä¸ă¤ä¸ă¤ćĺŽăăžăăăăççĽăăăă¨ăă§ăăžăă ĺĺćĺŽăăăŞăĺ ´ĺăŽINSERTćăŻă䝼ä¸ăŽéăă§ăă ďź ć¸ĺźďźĺĺćĺŽçĄăăżăźăł ďź INSERT INTO ăăźăăŤĺ VALUES (ĺ¤1, ĺ¤2, ...) ; âťćł¨ćçš ĺĺćĺŽăăăŞăĺ ´ĺăŽăĺ¤ăăŻăĺĺé éăăŤćŁăăćĺŽăăăăă注ćăă ăăďź â SQL ć --SQLćďźINSERTăŽĺşćŹ(ĺĺćĺŽçĄďź INSERT INTO sample_animal VALUES ( 1 , ' çŹ ' , ' ć´çŹ ' , ' 弳 ' , 1 , null ); INSERT INTO sample_animal VALUES ( 2 , ' çŹ ' , ' ć´çŹ ' , ' çˇ ' , 2 , null ); INSERT INTO sample_animal VALUES ( 3 , ' çŹ ' , ' ăăŻăŻ ' , ' çˇ ' , 1 , null ); ĺŽčĄçľćăŻĺĺăćĺŽăăçľćă¨ĺ¤ăăăžăăă ĺĺăćĺŽăăŞăĺ ´ĺăŻă¨ăŚăăˇăłăăŤä¸ă¤ăäžżĺŠăŤčŚăăžăăăćłĺŽăăŚăăŞăăăŠăăŤăçşçăăăŞăšăŻăăăăžăă ĺĺćĺŽăăăŞăINSERTćă使ăéăŻăă注ćăăă ăăŞăăăĺŠç¨ăă ăăă č¤ć°ăŹăłăźăăĺćINSERT çśăăŚăč¤ć°ăŹăłăźăă1ă¤ăŽINSERTćă使ăĺćăŤčż˝ĺ ăăĺ ´ĺă誏ćăăžăă ĺčż°ăăINSERTăŽĺşćŹăăçč§Łăăă ăăŚăăă°ăă¨ăŚăç°ĄĺăŞćšćłă§ăă ďź ć¸ĺź ďź INSERT INTO ăăźăăŤĺ VALUES (ĺ¤1-1, ĺ¤1-2, ĺ¤1-3), (ĺ¤2-1, ĺ¤2-2, ĺ¤3-3) ... ; ă§ăŻăĺŽéăŤĺ¤ăĺ
ĽăăŚăżăŚăżăžăăăă â SQL ć --SQLćďźč¤ć°ăŹăłăźăĺćINSERT INSERT INTO sample_animal VALUES ( 1 , ' çŹ ' , ' ć´çŹ ' , ' 弳 ' , 1 , null ), ( 2 , ' çŹ ' , ' ć´çŹ ' , ' çˇ ' , 2 , null ), ( 3 , ' çŹ ' , ' ăăŻăŻ ' , ' çˇ ' , 1 , null ); âĺŽčĄçľć animal _no animal_name animal_breed animal_sex skill _no skill_name 1 çŹ ć´çŹ ĺĽł 1 (null) 2 çŹ ć´çŹ çˇ 2 (null) 3 çŹ ăăŻăŻ çˇ 1 (null) VALUESăŽĺžăŤĺćINSERTăăăĺ¤ăćĺŽăăŚăăăŽăăăĺăăăăă ăăăŽă§ăŻăŞăă§ăăăăďź INSERTćă1ă¤ăă¤ć¸ăăăăĺšççă§ăăă ĺĽăăźăăŤăŤINSERT ĺĽăăźăăŤăŤĺăĺăăăĺŚçă§ăăăĺŻĺĺăďźăľăăŻă¨ăŞďźăă使ăŁăăINSERTćăŤă¤ăăŚă誏ćăăžăă äťĺĺŠç¨ăăăăźăăŤăŽćşĺăĺ
ăŤăăžăăăă ĺăăŤäťĺSELECTćă§ĺźăłĺşăăsample_animalăăźăăŤăŽăăźăżă䝼ä¸ăŽĺ
厚ă§UPDATEăăžăă skill _no ă1ăŽĺ ´ĺďźčľ°ă skill _no ă2ăŽĺ ´ĺďźéŁăś â SQL ć --SQLćďźsample_animalăăźăăŤăUPDATE UPDATE sample_animal SET skill_name = ' čľ°ă ' WHERE skill_no = 1 ; UPDATE sample_animal SET skill_name = ' éŁăś ' WHERE skill_no = 2 ; âĺŽčĄçľć animal _no animal_name animal_breed animal_sex skill _no skill_name 1 çŹ ć´çŹ ĺĽł 1 čľ°ă 2 çŹ ć´çŹ çˇ 2 éŁăś 3 çŹ ăăŻăŻ çˇ 1 čľ°ă ĺŽčĄçľćăŽăăăŤăŞăăžăăăďź ă§ăŻă揥ăŤäťĺSELECTă§ĺźăłĺşăăĺ¤ăć¸ăĺşăăsample_skill ăăźăăŤăCREATEăăŚăżăžăăăă â ĺĺŽçžŠ ĺĺ ăăźăżĺ PK skill _no integer â skill_name text â SQL ć --ăăźăăŤä˝ćSQLć CREATE TABLE sample_skill ( skill_no integer primary key, skill_name text ); ăăăžă§ćĽăžăăăćşĺĺŽäşă§ăă ă§ăŻăsample_animalăăźăăŤăăSELECTă§ĺźăłĺşăăĺ¤ăĺĽăăźăăŤă§ăăăsample_skill ăăźăăŤăŤINSERTăăŚăżăžăă ĺŠç¨ăăć¸ĺźăŻäťĽä¸ăŽéăă§ăă ďź ć¸ĺź ďź INSERT INTO ăăźăăŤĺ1 (ĺĺ1, ĺĺ2, .... ) ă SELECT ăăźăăŤĺ2.ĺĺ FROM ăăźăăŤĺ2 WHERE ćĄäťś; SQL ćăăăăăŚăżăžăăăďź â SQL ć --SQLćďźĺĽăăźăăŤăŤINSERT INSERT INTO sample_skill SELECT sample_animal.skill_no, sample_animal.skill_name FROM sample_animal WHERE animal_no IN ( 1 , 2 ); âĺŽčĄçľć animal _no animal_name animal_breed animal_sex skill _no skill_name 1 çŹ ć´çŹ ĺĽł 1 čľ°ă 2 çŹ ć´çŹ çˇ 2 éŁăś 3 çŹ ăăŻăŻ çˇ 1 čľ°ă skill _no skill_name ă ă ăđ skill _no skill_name 1 čľ°ă 2 éŁăś ä¸č¨ĺŽčĄçľćăŽéăăăšăăŤă ăăć˝ĺşăăăă¨ăă§ăăžăăă INSERTćăŽä˝żăćšăŽčŞŹćăŻäťĽä¸ă¨ăŞăăžăă ăăăINSERTćă ăă§ăŞăăCREATEć/ SELECTć/UPDATEćăä˝ăčŚăăŤć¸ăăäşşăŻă揥ăšăăăă§ăă SQL ă§ăŽăăăŠăźăăłăšăăĽăźăăłă°ăŤććŚăăăŽăăăăăă§ăďź ăăăăăŽć¸çą ăăăă SQL ăĺŚăłăăćšăŤăăăăăăŽ3ĺăŻăăĄăďź â ăšăăăŞăăă SQL ĺ
Ľé 珏2ç â ă¤ăŠăšăă§çč§Łă SQL ăăŻăăăŚĺ
Ľé â SQL 珏2ç ăźăăăăŻăăăăăźăżăăźăšćä˝ (ăăă°ăŠăăłă°ĺŚçżăˇăŞăźăş) DBč¨č¨ăăăăŠăźăăłăšăăĽăźăăłă°ăĺŚăłăăćšăŤăăăăăăŽ4ĺăŻăăĄăďź â SQL ĺŽčˇľĺ
ĽéââéŤéă§ăăăăăăăŻă¨ăŞăŽć¸ăćš â SQL ăăăŠăźăăłăščŠłč§Ł â SQL ă˘ăłăăăżăźăł â éäşşăŤĺŚăśDBč¨č¨ ĺžšĺşćĺ㏠INSERT ăžă¨ă ăăăă§ăăă§ăăăăďź äťĺăŻă SQL ĺ
Ľéă¨ăăžăăŚăINSERT ăžă¨ăăăăç´šäťăăăŚăăă ăăžăăă ĺŽéăŤăćĺ
ă§ SQL ăĺăăăă¨ă§ăăăçč§Łă桹ăăăă¨ăă§ăăăŽă§ăŻăŞăă§ăăăăă ćšăăžăăŚăćŹč¨äşăINSERTćăĺŚăśćšăŤă¨ăŁăŚăĺ°ăă§ăă彚ăăŚăă°ĺš¸ăă§ăă ćĺžăžă§ăčŞăżăăă ăăăăă¨ăăăăăžăăďź ă¨ăłă¸ă㢠ä¸éćĄç¨ ăľă¤ă ăŠăŻ ăšă§ăŻăă¨ăłă¸ăă˘ăťăăśă¤ăăźăŽ ä¸éćĄç¨ ăçŠćĽľçăŤčĄăŁăŚăăăžăďź ăčĺłăăăžăăăćŻéă確čŞăăéĄăăăžăă https://career-recruit.rakus.co.jp/career_engineer/ ăŤă¸ăĽă˘ăŤé˘čŤăçłčžźăżăăŠăźă ăŠăŽčˇç¨ŽăŤĺżĺăăă°čŻăăăăăăŞăă¨ăăćšăŻăăŤă¸ăĽă˘ăŤé˘čŤăéćčĄăŁăŚăăăžăă 䝼ä¸ăăŠăźă ăăăçłčžźăżăă ăăă rakus.hubspotpagebuilder.com ăŠăŻ ăšDevelopersçťé˛ăăŠăźă https://career-recruit.rakus.co.jp/career_engineer/form_rakusdev/ ă¤ăăłăć
ĺ ą äźç¤žăŽé°ĺ˛ć°ăçĽăăăćšăŻăćŻéąéĺŹăăŚăăă¤ăăłăăŤăĺĺ ăă ăăďź âTECH PLAY techplay.jp âconnpass rakus.connpass.com