èµ·ããäº æ¬çªç°å¢ã®ãã¼ã¿èª¿æ»ã®ä¾é ¼ãåããããã®èª¿æ»ãåããåã«ãããã¨ã¯å¥ã§ä¸è¦ãã¼ã¿ãæ¬çªDBããåé¤ããä½æ¥ãMySQL Workbenchã§è¡ã£ã¦ããã æ¬çªDBã§ããã¼ã¿èª¿æ»ãè¡ãéã«MySQL Workbenchã§SQLã®selectã¨ééãã¦deleteãå®è¡ãã¦ãã¾ããTableã1ã¤ä¸¸ãã¨Deleteãã¦ãã¾ã£ãã ON DELETE CASCADEã親ãã¼ãã«ã«è¨å®ããã¦ãã¾ã£ã¦ãããããããã«4ã¤ã®Table dataãèã¥ãå¼ã«æ¶ãã¦ãã¾ã£ãã ON DELETE CASCADEã®èª¬æã¨ãã¦ã¯ããã®è¨äºãããããããã£ãã§ãã https://www.dbonline.jp/mysql/table/index11.html ãã¼ãã«ã®æ§æ(ãã¼ãã«åãªã©ã¯ä¾ã¨ãã¦æãã¦ãã¦ãå®éã®ãã®ã¨ã¯å¤å°ç°ãªãã¾ã) æ£ããè¨å® usersãã¼ãã«ã§userãåé¤ããæã«ãã
{{#tags}}- {{label}}
{{/tags}}