Setting up a lab or project for MySQL is very similar to other languages on AutoGradr. Since MySQL is a database query language, there are a few things to know about.
The sample question is a good starting point, as it demonstrates how the question should be set up, and how it will run for the students.
Try running this as the solution for the sample question:
USE autogradr; CREATE TABLE cats ( id INT unsigned NOT NULL AUTO_INCREMENT, # Unique ID for the record name VARCHAR(150) NOT NULL, # Name of the cat owner VARCHAR(150) NOT NULL, # Owner of the cat birth DATE NOT NULL, # Birthday of the cat PRIMARY KEY (id) # Make the id the primary key ); DESCRIBE cats;