Write a MySQL command to create a table called CANDY that co…
Write a MySQL command to create a table called CANDY that contains the following columns:Candy ID, five characters; will function as primary keyCandy name, 25 charactersDescription, 50 charactersQuantity per unit, whole number