mysql　DB

トリガーとは

https://dev.mysql.com/doc/refman/8.0/ja/triggers.html
https://www.javadrive.jp/mysql/trigger/index1.html

アリアス？→　エイリアス　参考：https://wa3.i-3-i.info/word1149.html

DDLとは？

https://products.sint.co.jp/siob/blog/sql#:~:text=DDL（Data Definition Language）は,際に使用します。

dump ダンプ　バックアップ

https://www.sejuku.net/blog/82770

https://qiita.com/ryuuuuuuuuuu/items/c8f4525036e29d77be28

https://wa3.i-3-i.info/word1569.html

MY SQL 操作

https://mysql.sql55.com/sql/mysql-alter-table.php
https://tm.root-n.com/database:mysql:command:alter
https://learning-collection.com/mysqlのコマンド集/

https://uxmilk.jp/12612
https://www.javadrive.jp/mysql/table/index18.html
https://www.javadrive.jp/mysql/table/index21.html
https://qiita.com/miriwo/items/ae4672e6125a7dfb0f95
https://yukun.info/alter-table-add-drop-change-modify/

https://www.oracle.com/jp/education/index-172250-ja.html

inner join
outer join
図式

https://amg-solution.jp/blog/26287
https://amg-official.s3.ap-northeast-1.amazonaws.com/wp-content/uploads/2021/09/16155729/join-ic.jpg

SQL　コツ
https://atmarkit.itmedia.co.jp/ait/articles/0707/25/news124.html
https://zenn.dev/forcia_tech/articles/202304_db_rapid_search_strategy
https://www.w2solution.co.jp/corporate/tech/eg_ti_ti_sql5/
https://zenn.dev/ttskch/articles/4c1612a99b1459
https://style.potepan.com/articles/26070.html
https://style.potepan.com/articles/25846.html

サブクエリ
https://products.sint.co.jp/siob/blog/what-is-sql-subquery
https://snome.jp/database/sql-sub-query/

テーブルの結合
https://it-road.com/oracle-outer-join/
https://techplay.jp/column/1743
https://x-tech.pasona.co.jp/media/detail.html?p=9465
https://image.itmedia.co.jp/l/im/ait/articles/0102/17/l_r5gamen02.jpg
https://z-marketing.net/sql-join/
https://detail.chiebukuro.yahoo.co.jp/qa/question_detail/q10233849765
http://pgcafe.moo.jp/SQL/main_2.htm
https://products.sint.co.jp/topsic/blog/sql-bootcamp-07
https://pgcafe.moo.jp/new/SQL/index.php
https://zenn.dev/naoki_mochizuki/articles/60603b2cdc273cd51c59