All Questions
5 questions
0
votes
1
answer
211
views
Subtract to numbers in relation to time/date specific query in Mysql // Nodered
hy, beeing a noob in mysql i am trying to substract two numbers in relation to a time/date specific query:
Trying to display the actual daily power consumption of my house i can extract the total ...
- 51
0
votes
2
answers
132
views
SQL Bit operation, change second last bit to 0
i have a lot of rows with an bigint(length 20) and i have to change every second last bit to 0.
For example i have: 0101 1011 and the result i need is: 0101 1001
The Problem is, the numbers are "...
- 15
-1
votes
1
answer
3k
views
SQL Operation to add 1000 to every number in a database row
I have some game servers that I run, and as my players play, they collect in game money for time played and PVP players killed, and use it to purchase gear in game. I recently had some downtime and ...
- 317
1
vote
1
answer
55
views
SQL order by the result of one operation
I need to order the result of this query by the result of (LIKES (puntuacion=1) - DISLIKE (puntuacion=0).
This is the old query where I order by the sum of likes (puntuacion=1).
"SELECT entradas.* , ...
- 73
1
vote
3
answers
3k
views
MySQL: Performing an operation on different rows based on condition?
Say I have a query which returns the following result:
| val | type | i |
----------------------
| 59 | 1 | 1 |
| 40 | 2 | 2 |
| 12 | 1 | 3 |
| 3 | 2 | 4 |
| 24 ...
- 4,999