MySQL从一个表往另一个表中导出数据，并处理时间格式

像素鱼丸  2018-10-26 MySQL  1756

INSERT INTO tp_article(
    name,
    user_id,
    category_id,
    thumbnail,
    content,
    description,
    create_time,
    tags
)
SELECT 
    title,
    FLOOR(2 + (RAND() * 10)),
    category,
    thumbnail,
    content,
    description,
    UNIX_TIMESTAMP(create_time) + ceiling(rand() * 100),
    tags
FROM s_article;