I have a movie ranking system on my site and I need it NOT to show how many users have recommended such a movie, here's my code:
$query = "SELECT DISTINCT filmes, count(filmes) FROM filmes_rec
GROUP by filmes
ORDER by co...
When I run liquibase it does not find .slq files configured by the tag. SQLFile. How do you solve this?
Problem data:
Use in the project Liquibase 3.4.2.
Configure the maven plugin
Run script in Maven Ok everything works (Windows +...
I have a sequence of values, for example:
w1-16
w2-16
w3-16
w4-16
w5-16
w6-16
w7-16
w8-16
w9-16
w10-16
w11-16
There you go.
I made a query that takes the correct sequence as above. Example:
select week from tabela where group by week...
I'm having a hard time checking the login with Delphi with encrypted password in the MySQL database, I can do the registration
and encrypt the password in the database through Delphi with the StoredProcedure that I cr...
I need to create a query that calculates the average of a vendor "score". Here is the query, and then the explanation of the fields:
SELECT distinct C7_FILIAL,
CASE WHEN C7_FILIAL = '0201' THEN '0201 - METAIS'
WHEN C7_FILIAL = '...
Good morning everyone!
I currently work with postgresql and I'm doing a database migration, and I need to create a view of my old database tables. Well, I need the number columns to round with 15.3 but I'm finding a problem that I can not fig...
Good evening, I'm using the following command:
select
cliente_id,
desconto,
pedidos_detalhes.pedido_id,
cliente_tipo
from
pedidos_detalhes
inner join
pedidos on pedidos_detalhes.pedido_id = pedidos.pedido_id;
The res...
I have a file in * .sql. I needed to batch convert HTML codes with links like this below:
<img src="http://www.sintaema.org.br/site/wp-content/uploads/bomba-456-copy_832-1-pdf-724x1024.jpg"alt="bomba 456 copy_832 1" />'
To look like t...