2023/5/29開催Dojoの資料です。
IBM Developer
View Slide
2Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
3Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
4Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
5Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
6Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
7Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
8Customer Success, IBM Technology, Japan / © 2023 IBM Corporation(DB) ..
9Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
10Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
11Customer Success, IBM Technology, Japan / © 2023 IBM Corporation2
12Customer Success, IBM Technology, Japan / © 2023 IBM Corporation2
13Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
14Customer Success, IBM Technology, Japan / © 2023 IBM CorporationSQL
15Customer Success, IBM Technology, Japan / © 2023 IBM CorporationSQL
16Customer Success, IBM Technology, Japan / © 2023 IBM Corporation .. SQL
17Customer Success, IBM Technology, Japan / © 2023 IBM Corporation .. SQL
18Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
19Customer Success, IBM Technology, Japan / © 2023 IBM CorporationPaiza.iohttps://paiza.io/ja/projects/new?language=mysqlmyCompilerhttps://www.mycompiler.io/es/new/mysqltrysql_editorhttps://www.w3schools.com/mySQl/trymysql.asp?filename=trysql_editorOneCompilerhttps://onecompiler.com/mysql
20Customer Success, IBM Technology, Japan / © 2023 IBM Corporation※ SQLshow databases;
21Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 1test
22Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 1CREATE TABLE Test(id int, title text);SQL( )SQL( )CREATE TABLE [ ]([ 1] [ ], [ 2] [ ]..);SQL
23Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 1INSERT INTO Test(id, title) VALUES (1," ");SQL( )SQL( )INSERT INTO [ ]([ 1], [ 2]..) VALUES ([ 1],[ 2]..);SQL
24Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 1SELECT * FROM Test;SQL( )SQL( )SELECT [ ] FROM [ ];SQL
25Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 2
26Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 2UPDATE Test SET title=" ";SQL( )SQL( )UPDATE [ ] SET =“[ ]";SQL
27Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 2ALTER TABLE Test RENAME COLUMN title TO greeting;SQL( )SQL( )ALTER TABLE [ ] RENAME COLUMN [ ] TO [ ];SQL
28Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 3
29Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 3DELETE FROM Test;SQL( )SQL( )DELETE FROM [ ]SQL
30Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 3SQL( )DROP TABLE Test;SQL( )DROP TABLE [ ];SQL
31Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 4
32Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 4CREATE TABLE Test(id integer, title text);INSERT INTO Test(id, title) VALUES (1," ");INSERT INTO Test(id, title) VALUES (2," ");SELECT * from Test;SQL
33Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 4SELECT [ ] FROM [ ] WHERE [ ];SQLSELECT * FROM Test WHERE id= 2;UPDATE [ ] SET title=" [ ] " WHERE [ ];UPDATE Test SET title= " " where id = 2;
34Customer Success, IBM Technology, Japan / © 2023 IBM Corporation- 4SELECT [ ] FROM [ ] ORDER BY [ ] [ or ]SQL ORDER BYSELECT * FROM Test ORDER BY id DESC;※ASCDESC
35Customer Success, IBM Technology, Japan / © 2023 IBM CorporationSELECT No, , , … FROM sales WHERE = 3/15Sales
36Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
37Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
38Customer Success, IBM Technology, Japan / © 2023 IBM Corporation
39Customer Success, IBM Technology, Japan / © 2023 IBM CorporationRDB NoSQL