mysql 时间戳截断_列的Mysql时间戳数据被截断

我试图使用python在mysql数据库创建的列中插入时间戳。

这是我的数据库表设置。。CREATE TABLE temps (

temp1 FLOAT, temp2 FLOAT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

temp1和temp2并正确填充，但收到时间戳错误Warning: Data truncated for column 'created_at' at row 1

cursor.execute("""INSERT INTO temps VALUES (%s,%s,%s)""",(avgtemperatures[0],avgtemperatures[1],st[2]))

((71.7116, 73.2494, None),)

下面是python脚本的一节，它将信息插入到数据库中。#connect to db

db = MySQLdb.connect("localhost","user","password","temps" )

#setup cursor

cursor = db.cursor()

ts = time.time()

st = datetime.datetime.fromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')

sql = """CREATE TABLE IF NOT EXISTS temps (

temp1 FLOAT,

temp2 FLOAT,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP)"""

cursor.execute(sql)

#insert to table

try:

cursor.execute("""INSERT INTO temps VALUES (%s,%s,%s)""",(avgtemperatures[0],avgtemperatures[1],st[2]))

db.commit()

except:

db.rollback()

#show table

cursor.execute("""SELECT * FROM temps;""")

print cursor.fetchall()

((188L, 90L),)

db.close()

这里是数据库的转储：Dumping data for table temps

temp1 temp2 created_at

71.7116 73.2494 0000-00-00 00:00:00