mysql获取时间精确到纳秒

-- 创建表
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_time BIGINT
);

-- 插入数据
INSERT INTO events (event_time) VALUES (UNIX_TIMESTAMP(NOW()) * 1000000000 + MICROSECOND(NOW()) * 1000);

-- 查询数据并转换
SELECT id, FROM_UNIXTIME(event_time / 1000000000) AS event_datetime, (event_time % 1000000000) AS nanoseconds FROM events;

import time
import mysql.connector

# 连接数据库
db = mysql.connector.connect(host="localhost", user="user", password="password", database="test")
cursor = db.cursor()

# 获取当前时间的纳秒部分
current_time = time.time()
nanoseconds = int((current_time - int(current_time)) * 1000000000)

# 插入数据
cursor.execute("INSERT INTO events (event_time) VALUES (%s)", (int(current_time),))
db.commit()

# 查询数据并转换
cursor.execute("SELECT id, FROM_UNIXTIME(event_time) AS event_datetime, %s AS nanoseconds FROM events", (nanoseconds,))
result = cursor.fetchall()

for row in result:
    print(row)

cursor.close()
db.close()