I'm building my first DB through MySQL Workbench. In a table I need to store a time
attribute that contains minutes and seconds. In this regard, I wanted to use the TIME
data type. What is the argument required by the type TIME(...)
?
我正在通过MySQL Workbench构建我的第一个数据库。在表中,我需要存储包含分钟和秒的时间属性。在这方面,我想使用TIME数据类型。 TIME(...)类型所需的参数是什么?
2 个解决方案
#1
6
I solved, I entered TIME without parentheses. I thought that the type TIME required an input parameter.
我解决了,我没有括号进入TIME。我认为TIME类型需要一个输入参数。
CREATE TABLE IF NOT EXISTS
CookingDB
.Recipe
( ... CookingTime
TIME NULL, ...
CREATE TABLE如果不存在CookingDB.Recipe(... CookingTime TIME NULL,...
#2
1
As said in MYSQL docs:
如在MYSQL文档中所述:
MySQL retrieves and displays TIME values in 'HH:MM:SS' format
MySQL以'HH:MM:SS'格式检索并显示TIME值
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.
您必须使用TIME数据类型来表示一天中的时间,但是只存储您需要使用DATE_FORMAT以所需格式格式化时间所需的分钟和秒数。
On a side note, do note that TIME datatype takes 3 bytes of space.
另请注意,请注意TIME数据类型占用3个字节的空间。
#1
6
I solved, I entered TIME without parentheses. I thought that the type TIME required an input parameter.
我解决了,我没有括号进入TIME。我认为TIME类型需要一个输入参数。
CREATE TABLE IF NOT EXISTS
CookingDB
.Recipe
( ... CookingTime
TIME NULL, ...
CREATE TABLE如果不存在CookingDB.Recipe(... CookingTime TIME NULL,...
#2
1
As said in MYSQL docs:
如在MYSQL文档中所述:
MySQL retrieves and displays TIME values in 'HH:MM:SS' format
MySQL以'HH:MM:SS'格式检索并显示TIME值
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.
您必须使用TIME数据类型来表示一天中的时间,但是只存储您需要使用DATE_FORMAT以所需格式格式化时间所需的分钟和秒数。
On a side note, do note that TIME datatype takes 3 bytes of space.
另请注意,请注意TIME数据类型占用3个字节的空间。