每天向另一个表插入age值
我想把值放到数据库中该值是选择
的结果这是选择查询:
SELECT ROUND(DATEDIFF(NOW(),user_birthday)/365 )as age from user_info
如何通过使用计划事件
Mysql
支持insert...select
语句
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
[PARTITION (partition_name,...)]
[(col_name,...)]
SELECT ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]
select
INSERT INTO table_name_to__name data_has_to_be_copy (SELECT column_names FROM table_name WHERE condition);