Steps to create new database in Mysql Workbence-
- Open MYSQL workbench
- Right click in schemas
- Create new schema
- Change name to Analysis then apply
- Under Analysis schema right click tables
- Create table change table name to Teachers
- Within it there are 6 columns-
- id
- first_name
- last_name
- school
- hire_date
- salary
- Double click on column to enter column name and data type
- Then apply
- Run table to see all details
- In result grid double click null to insert the values in it
- Date format should be YYYY-MM-DD