-- 先建个表createtable test(
age int(4),
time_1 bigint(13))
要把时间戳转换为13位的整数,再插入表中
-- 每一行后面没加“‘;”,运行的时候一行一行运行insertinto test (age,time_1)values(1,REPLACE(unix_timestamp(current_timestamp(3)),'.',''))insertinto test (age,time_1)values(2,REPLACE(unix_timestamp(current_timestamp(3)),'.',''))insertinto test (age,time_1)values(3,REPLACE(unix_timestamp(current_timestamp(3)),'.',''))insertinto test (age,time_1)values(4,REPLACE(unix_timestamp(current_timestamp(3)),'.',''))insertinto test (age,time_1)values(4,REPLACE(unix_timestamp(current_timestamp(3)),'.',''))