Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var connection = mysql.createConnection(
- {
- host : 'hackteams.c6p7kpyzcymg.us-east-1.rds.amazonaws.com',
- user : 'test',
- password : 'password',
- database : 'hackteams'
- }
- );
- // username:
- var user = 'tiger';
- connection.query("SELECT * FROM users WHERE (id = (SELECT friend_id FROM user_has_friend WHERE (user_id = (SELECT id FROM users WHERE username = '" + user + "'))))", function(err, rows, field) {
- if (err) callback(err, null);
- for (i in rows) {
- // do something...
- console.log(rows[i]);
- }
- connection.end();
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement