➕How to create MySQL database item

Introduction

A MySQL database item is a type of item in which your students have to code within CodeChum and submit them for automatic checking.

CodeChum already has tons of built-in mysql-based item that you are free to use, but if you'd like to make your own item to use in an activity in CodeChum, you can make your own!

Steps

To create a mysql-based item in CodeChum, follow these steps:

1. Click on Item Bank. This will redirect you to a screen listing all items you have created within CodeChum.

   
2. Look for the Create Item button and click it. This will open a big popup window to create your very own item.

   
3. Select MySQL database as the item type.

   
4. Provide an item name and a description on what the item is all about. Be as detailed as possible.

   
5. Add test cases to check the solutions of your students. Tip: If you already have existing initialization queries in a .sql file, take advantage of our optional step by simply clicking the 'Convert database/table query' button. This feature allows you to seamlessly copy and paste your queries into the code editor. However, if you don't have one, just skip the optional steps and proceed to the next step, where you input your initialization queries manually.

   

   

   

   

   

   

   

   
6. Once done, click Create Item. It should show a popup window informing that you have successfully created your own item!

   

And that's how to make MySQL database items in CodeChum!