1. Install MySQL Server
- : https://dev.mysql.com/downloads/windows/installer/
- Both 32-and 64-bit are the same.
- It is recommended to choose the big one. 18M in the installation process also need to download, I next time super slow, so still one step download OK.
- You can choose server only when installing, the rest of the default is good
2. Install MySQL Workbench
- : https://dev.mysql.com/downloads/workbench/
- You need to set the root password when installing, the other default is good
- After installing, open Workbench, select Server, enter the root password you just set
3. Basic usage
- There is a default database sys in server and we can create it separately. You can see it after the schemas refreshes.
- In the query area
- If you want to write more than one line, you must add a semicolon after each line
- Shortcut keys for execution: Ctrl+enter
- If not selected, all statements in query are executed together, or they can be executed separately after the statement is selected.
- To operate on a database, you first need to use the
CREATE DATABASE scraping; use scraping;
[Database] Getting Started with MySQL server/workbench installation