Advertisement
Guest User

Untitled

a guest
Nov 20th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. var mysql = require('mysql');
  2. var connection = mysql.createConnection(
  3. {
  4. host : 'hackteams.c6p7kpyzcymg.us-east-1.rds.amazonaws.com',
  5. user : 'test',
  6. password : 'password',
  7. database : 'hackteams'
  8. }
  9. );
  10.  
  11. // username:
  12. var user = 'tiger';
  13.  
  14. 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) {
  15. if (err) callback(err, null);
  16. for (i in rows) {
  17. // do something...
  18. console.log(rows[i]);
  19. }
  20. connection.end();
  21. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement