app.get('/noticias',function(req , res){

var mysql = require('mysql');
var connection = mysql.createConnection({
    host :'localhost',
    user:'root',
    pass:'',
    database:'portal_noticias'
});

connection.query('select * from  noticias', function(error , result){
    // retorna o resultado para view
     res.render('noticias/noticias',{noticia : result});

});

</tr>

   <% for(var i=0;i<noticia.lenght;i++){ %>
        <%= noticia[i].id_noticias %> - <%= noticia[i].id_noticias %>