DB Binding - MySQL Sample DB Integration | Notion

[🌐KR](<https://synctree-guide.notion.site/DB-MySQL-Sample-DB-7800854f3f694bf69fa14f00365dcb5e>)

This document describes how to link DB data using DB Storage and Storage blocks.

Index

▶Storage

1) Create DB Storage

Untitled

No.	Function
1	Create DB Storage - Studio > Storage > DB Storage > + Create Storage
2	Select DB Type MySQL
3	Create Storage - Select the appropriate Group > Create Storage- Database Type : MySQL

2) Register Query

Untitled

No.	Function
1	Create Query - Studio > Storage > Query Manager > + Create Query
2	Enter relevant information in the Create Query window

Mapping ID : Use to call Query on NBlock
Query : Register query statements created by SQL grammar |

▶NBlock

1) Configure the data to be used as a Bind parameter in the Request Body

Untitled

2) Connect DB Storage and Query Blocks on BizUnit

Untitled

No.	Function
1	Getting data to be used as Bind parameter from Request Data {“a” : “1”}
2	DB Connector - Output DB Storage Information Connected by Apps
3	Register Query statement

Pairing by entering the Query ID registered in Query Manager in Query ID
Setting to get the a Value of request data with Bind parameter SELECT * FROM study.data where id=:a; > SELECT * FROM study.data where id=1; |

3) Check DB Data call results