Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "172.25.21.233",
- user: "root",
- password: "test",
- database :'hamid_makic'
- });
- var muski=0,zenski=0;
- con.connect(function(err) {
- if (err){
- console.log("error connecting:"+ err.stack);
- return}
- con.query("SELECT gender, COUNT(*) as count FROM employees GROUP BY gender;", function (err, result, fields) {
- if (err) throw err;
- console.log(result);
- con.end();
- // console.log(result.length);
- });
- console.log('connected as id '+ con.threadId);
- });*/
- /*var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "172.25.21.233",
- user: "root",
- password: "test",
- database :'hamid_makic'
- });
- var muski=0,zenski=0;
- con.connect(function(err) {
- if (err){
- console.log("error connecting:"+ err.stack);
- return}
- con.query("SELECT YEAR(birth_date) as godina, COUNT(*) as count FROM employees GROUP BY YEAR(birth_date);", function (err, result, fields) {
- if (err) throw err;
- result.forEach(function(result) {
- console.log('Uposlenika rodjenih '+ result.godina +' ima uposlenika ' + result.count + '.');
- });
- con.end();
- });
- });*/
- /*var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "172.25.21.233",
- user: "root",
- password: "test",
- database :'hamid_makic'
- });
- var muski=0,zenski=0;
- con.connect(function(err) {
- if (err){
- console.log("error connecting:"+ err.stack);
- return}
- con.query("SELECT last_name,first_name, COUNT(*) as 'izbrojano' FROM employees as e INNER JOIN titles ON e.emp_no=titles.emp_no GROUP BY e.emp_no HAVING izbrojano>1" , function (err, result, fields) {
- if (err) throw err;
- result.forEach(function(result) {
- console.log(result.first_name + " " + result.last_name);
- });
- con.end();
- });
- });*/
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "172.25.21.233",
- user: "root",
- password: "test",
- database :'hamid_makic'
- });
- var zaposlenici={};
- var temp;
- var muski=0,zenski=0;
- con.connect(function(err) {
- if (err){
- console.log("error connecting:"+ err.stack);
- return}
- con.query("SELECT last_name, first_name,YEAR(to_date) as godina FROM `employees` as e INNER JOIN dept_emp as de on e.emp_no=de.emp_no WHERE YEAR(to_date)<YEAR(CURDATE())" , function (err, result, fields) {
- if (err) throw err;
- for(i=0;i<result.length;i++)
- {
- console.log(result[i].first_name + " "+ result[i].last_name + " prestap da radi " + result[i].godina);
- }
- console.log(result.length);
- con.end();
- });
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement