Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "root",
- database: "list"
- });
- //fs.readFile('list.json', 'utf8', function (err, data)
- {
- if (err) throw err;
- var obj = JSON.parse(tableData);
- con.connect(function(err) {
- if (err) throw err;
- console.log("Connected!");
- for(var i = 0; i < obj.length; i++) {
- var s_at = obj[i].id;
- var sql = 'INSERT INTO members (scraped_at) VALUES ('+s_at+');
- con.query(sql, function (err, result) {
- if (err) throw err;
- console.log("x record inserted");
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement