我对我的数据库有一个查询,该数据库保存了面试的日期,我需要能够只提取当前月份和年份的面试,然后将它们与进行面试的人分组。$time = time();select count(i.interv_id) as cnt, u.user_name, year(from_unixtime($time)) as year, month(from_unixtime($time)) as monthleft join support.support_logs as l on l.log_id = i.log_id
因此,我试图使用一些数据和date = NOW()来更新表行,这似乎比我想象的更烦人。AND date = NOW() WHERE id = ?" , sql_query_data , function ...)这里还有另一个没有帮助的(我也理解为什么):
var sql_query_data = [{size:fileSize , loc:filename, date:"NOW()"} , row_id];