var mysql = require('mysql');
var nano = require('nano')('http://user:password@localhost:5984');
var db = nano.db.use('testdb');
var con = mysql.createConnection({
host: "blah-blah.rds.amazonaws.com",
user: "sync",
password: "MySQLSync"
});
var sql = "SELECT * FROM testdb.mytable WHERE UPDATED > '2018-04-16 16:00:00'";
con.connect(function(err) {
if (err) throw err;
console.log("Connected.");
});
con.query(sql, function(err, result) {
if (err) throw err;
db.bulk({docs:result}, function(err, body) {
if (err) throw err;
});
});
con.end();
1条答案
按热度按时间shyt4zoc1#
这是非常基本的,但我只是学习节点和couchdb。不过,这只是一个开始。其中一部分来自w3schools.com。