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.