Write a MySQL Command to Create a Table Called CANDY

Essay

Write a MySQL command to create a table called CANDY that contains the following columns:
.Candy ID, five characters; will function as primary key
.Candy name, 25 characters
.Description, 50 characters
.Quantity per unit, whole number