mysql 查询某表的所有列,获取毫秒时间戳

查询列

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='agvlaser' 
    AND `TABLE_NAME`='driver';

查询毫秒时间戳

select ROUND(UNIX_TIMESTAMP(CURTIME(4)) * 1000)

 

posted @ 2021-07-18 11:27  wolbo  阅读(485)  评论(0编辑  收藏  举报