| topic | reference |
|---|---|
| Data Types | https://dev.mysql.com/doc/refman/8.0/en/data-types.html |
| Operators | https://dev.mysql.com/doc/refman/8.0/en/non-typed-operators.html |
Engine is always on table level, we can specify different engines for different tables.
| File Name | File Path |
|---|---|
| mysql profiles path | C:\Program Files\MySQL\MySQL Workbench 8.0 CE\mysql.profiles\Windows_(MySQL_8.0_Installer_Package).xml |
| config file path | %ProgramData%\MySQL\MySQL Server 8.0\my.ini |
| Data storage path | %ProgramData%\MySQL\MySQL Server 8.0\Data |
notes:Employee Data from mysql.com
TestData: https://github.com/datacharmer/test_db management -> data export -> select objects to export -> export to project folder or export to self-contained file