How to use TIME type in MySQL?

I solved, I entered TIME without parentheses. I thought that the type TIME required an input parameter.

CREATE TABLE IF NOT EXISTS CookingDB.Recipe ( ... CookingTime TIME NULL, ...


As said in MYSQL docs:

MySQL retrieves and displays TIME values in 'HH:MM:SS' format

You have to use the TIME data type to represent the time of the day however to store only the minutes and seconds you need to use the DATE_FORMAT to format your time in your desired format.

On a side note, do note that TIME datatype takes 3 bytes of space.