Search for a command to run...
I am a backend developer (PHP, Javascript, Laravel, Node ) , I know frontend (css, html, react, react-native) but it is not my passion, I have experience as a linux system administrator. I have deployed products in googlecloud, I have experience with integration and maintenance to mobile applications, in addition to working with database sql (mysql, postgresql) and nosql (mongodb)
No comments yet. Be the first to comment.
Programming Languages war
Programming Languages war
Define Variables Hey, my friends, a new post about this war. I don't know which is better, but I'll try to figure it out. I hope y'all enjoy this series. Here we go! In this opportunity I'm going to check up the deep basic information that these lang...
Install new fighters
In this post, I'm going to write a hangman game. Hangman game is a game where you choose a letter until you find the word Here we go! # Library to get numbers random. import random # Library to manipulate the console. import os # The function to rea...
Hey my friends, a new post about this war. I don't know which is better, but I'll try to figure it out. I hope y'all enjoy this series. Here we go!
This time I'm going to talk about a few queries that can help you!
If you need to count how many registers exist with the same query.
SELECT count(*) FROM crews WHERE captain = 'Luffy';
db.crews.find({"captain":"Luffy"}).count()
If you need to sum a specific field.
SELECT SUM(members) FROM crews;
db.crews.aggregate(
{
$match:{}
},
{
$group: {
_id: null,
sum: {
$sum: "$members"
}
}
});
If you need to get the min field of a query.
SELECT MIN(members) FROM crews;
db.crews.aggregate(
{
$match:{}
},
{
$group: {
_id: null,
min: {
$min: "$members"
}
}
});
If you need to get the max field of a query.
SELECT MAX(members) FROM crews;
db.crews.aggregate(
{
$match:{}
},
{
$group: {
_id: null,
max: {
$max: "$members"
}
}
});
Conclusion
Would you like to learn about other things?
I hope you enjoy my post and remember that I am just a Dev like you!