YLmSHCqD

1var mysql = require('mysql');
2
3var con = mysql.createConnection({
4  host: "localhost",
5  user: "zeev",
6  database: "assaf"
7});
8
9con.connect(function (err){
10  if (err) throw err;
11  console.log("Connected as zeev (admin)");
12  // create DATABASE
13  /*
14  con.query("CREATE DATABASE assaf", function (err,result){
15    if (err) throw err;
16    console.log("Database created");
17  })
18
19  var myQuery = "CREATE TABLE IF NOT EXISTS  drugDealer (name VARCHAR(255), tel VARCHAR(255))"
20  con.query(myQuery, function(err,result){
21    if (err) throw err;
22    console.log("drugDealer table was created!");
23  })
24
25  var myQuery = "ALTER TABLE drugDealer ADD COLUMN containerId INT";
26  con.query(myQuery, function(err,result){
27    if (err) throw err;
28    console.log("changed the table succsefully!");
29  })
30
31  var myQuery = "INSERT INTO drugDealer (name,tel,containerId) values ('Juliana','0545464563',13)";
32  con.query(myQuery, function(err,result){
33    if (err) throw err;
34    console.log("add new record!");
35  })
36  */
37  //var myQuery = "SELECT * FROM drugDealer";
38  //var myQuery = "SELECT name FROM drugDealer GROUP BY name";
39  //var myQuery = "SELECT * FROM drugDealer WHERE name='Juliana'";
40  //var myQuery = "SELECT * FROM drugDealer WHERE name LIKE 'B%'";
41  //var myQuery = "SELECT * FROM drugDealer ORDER BY tel DESC";
42  //myQuery = "DELETE FROM drugDealer WHERE name='Juliana' AND containerId=13";
43  var myQuery = "DROP TABLE narco";
44  con.query(myQuery, function(err,result,fields){
45    if (err) throw err;
46    console.log(result);
47    //console.log(fields[1].name);
48    console.log ("table was deleted!");
49  })
50});