Question:
-
connection:
- root connection和一般connection的区别?
- what does host mean? how to configure host? what is port 3306 used for?
-
字符集与校对规则:
- 用处?
- table可以设置不同于schema的字符集和规则?
Step: 参考 https://blog.csdn.net/u014551745/article/details/83147790
-
创建新的root以外的连接connection
-
创建数据库Schema:
- 设置字符集和校对规则: utf8, utf8-bin for Chinese
- CREATE SCHEMA `edge` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
- online DDL configuration: default
- 设置字符集和校对规则: utf8, utf8-bin for Chinese
-
创建数据表Table:
-
engine?
- 表头数量极多,如何创建和设置类型:导入一个行数较少的表,设置表头
-
-
导入数据表
-
table import wizard...
-