课程: Databases for Node.js Developers (2021)

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Create a database schema

Create a database schema

课程: Databases for Node.js Developers (2021)

开始一个月试用 购买团队方案

Create a database schema

“

- [Instructor] Let's now use MySQL to implement our maxcoin sample. Other than Redis and MongoDB, relational databases like MySQL rely on static table structures so-called 'schemas' to have to be defined directly inside the database. For larger systems, creating the database design is actually a science of its own. The maxcoin application though is very simple. So let's create the schema for it now. So I'm in MySQL workbench and I have the Schemas tab open and there I now right click and click on 'create schema'. And for the schema name, I will now just insert 'maxcoin'. We can leave the default for the character set and the collation which is used for sorting of strings. Next, I will click on 'apply'. And there my SQL workbench shows me the.... Actually comments that it will execute on the database and it creates schema command for the database, 'maxcoin'. Next I click apply and then I can close this. Now I have a database…

内容