From 1f80c689dc1f8261d8bdf143580b648121c5bbe0 Mon Sep 17 00:00:00 2001 From: 沈斌 <bluelazysb@hotmail.com> Date: Wed, 31 Jan 2018 17:14:52 +0800 Subject: [PATCH] test --- server2.js | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/server2.js b/server2.js index 75b1d10..fc64e11 100644 --- a/server2.js +++ b/server2.js @@ -9,11 +9,11 @@ //console.log("connected to MySQL"); }); -var partition_name = "p" + moment().add(2, 'd').format("YYYYMMDD"); -var partition_date = moment().add(3, 'd').format("YYYYMMDD"); +var partition_name = "p" + moment().add(1, 'd').format("YYYYMMDD"); +var partition_date = moment().add(2, 'd').format("YYYYMMDD"); var sql = "ALTER TABLE history ADD PARTITION (PARTITION " + partition_name + " VALUES LESS THAN ('" + partition_date + "'))"; -//console.log(sql); +console.log(sql); mysqlClient.query(sql, function (error, results, fields) { if (error) throw error; -- Gitblit v1.8.0