Step by step guide on creating and navigating a MySQL assignment
Create A New Assignment
Select New Assignment
Select MySQL Workbench
Enter an Assignment Name
Press Save And Continue
Uploading Data and Content
Configure Workspace
From the new assignment settings navigate to Configure Workspace
This is where you will upload content and data to be shared to your students
File Tree
Place .csv files or course content you want to be shared with students under the voc/startercode folder.
Student View
Student View can be accessed from either an assignment's settings page or from within the teacher view, Configure Workspace.
Instructors can simulate the student experience to test their content in the MySQL Workbench app.
Within MySQL Workbench the content you placed in voc/startercode is made available in the home directory.
How to Copy/Paste work into MySQL Workbench
In your lab the copy and paste features are done so through the browser. This is a simple process that requires you to first paste the content to the clipboard. Then you can reference the content within MySQL Workbench.
Open the clipboard in your environment
CTRL + OPT + SHIFT (MAC)
CTRL + ALT + SHIFT (WINDOW/LINUX)
Paste your copied content into the clipboard
CMD + V (MAC)
CTRL + V (WINDOWS/LINUX)
Close the clipboard window with the same commands to open
CTRL + OPT + SHIFT (MAC)
CTRL + ALT + SHIFT (WINDOW/LINUX)
Now you can paste the contents of the clipboard
CTRL + V
This will be the command to paste regardless of your local machine
We have also included a guide for students to navigate MySQL Workbench here