I'm trying to make a select that lists in a range of 10 minutes a value of the bank, is there any way to show the data even though it does not have data in the range correctly?
Example :
00:00:00 = 0
...
I am putting together a proc, but depending on the value of a parameter, I would like the left join to be different.
I have tried the querys below:
This works, however, else as null or even else , if the parameter
COD_...
I'm doing a query in the database (mysql) where I have a code and through this code there are several types of people.
I need when I make query come like this
ID | NOMES
1 | Fulano 1, Fulano 2, Fulano 3
2 | Fulano 2, Fulano...
I have a table with images, images , in which one of these columns ( file_name ) has image names, jpg other png , what I need is to change, make UPDATE all to the extension png , that is, change any extensio...
I have a separate table in MYSQL with the addresses of the users containing the location information (latitude and longitude), each user being able to have more than one registered address. My goal is that when performing a search for a location...
How can I use LIKE for a comparison of two different table fields? I need to compare the first 5 characters of each field. I tried SUBSTRING and with LEFT , however, the performance gets pretty bad.
Here are two ways I applied, with the c...
Good morning,
I have a query that is returning only the months with sales consumption, which should be the correct one. But now a blessed user wants me to come back every month, even those who have not had sales. How do I return as zero inclu...
The sales table has the following structure:
id_venda | nome_cliente | data_venda | data_agendamento | data_cancelamento | data_ligacao
Where the "date" fields are all datetime.
I would like to sort according to the last move that occurred....
I have the secretaries table with the following structure:
Andtheworkertablewiththefollowingstructure: Ilinkedtheworkertabletothesecretariestablethroughthefollowingrelation:
That is, I'm relating the Foreign key to the 'worker' table's pri...