gistfile1.js

var mysql = require('mysql');
 
var client = mysql.createConnection({
  host: 'localhost',
  user: 'omeka',
  password: 'omeka',
  port: 8889,
  database: 'neatline'
});
 
client.connect();
 
// Create exhibit.
var sql = 'INSERT INTO exhibits (title) VALUES ("dev")';
 
client.query(sql, function(err, res) {
 
  // Create row, using the insert id of the first query
  // as the exhibit_id foreign key.
  sql = 'INSERT INTO records (exhibit_id) '+
    'VALUES('+res.insertId+')';
 
  client.query(sql);
 
});