I have a table that contains a field with some values in braces, how do I exclude the chaves and the valores that are inside them?
Example:
cod | Movimento |
01 | Prazos {aguardando} |
Prazos {aguardando}...
I have a database with a date in the field start , I would like to display only the birthday of the current month in fullcalendar , but I have two difficulties:
Select only the birthdays of the current month
Show birthdays i...
I have the following question. Consider that I have the following sales data:
Two states: São Paulo (Atibaia, São Paulo and Campinas) and Paraná (Londrina, Curitiba, Cascavel).
| cidade | estado | vendas |
|-----------|--------|--------|...
I have the query below where it is done on the current day, how could I make the same query in the current month until today, example: 01/09 13/09 but so that the query tomorrow is: 01/09 to 14/09 and so on.
SELECT
o.numero...
I have 3 Tables
Table Produtos with columns id , descricao , peso . Table op_itens with columns id_op , id_prod (chave estrangeira da tabela Produtos com a coluna id) , qtd .
I want to...
In the image above I have mapped the separation positions inside the warehouse where I work.
I need to calculate the distance that the person who is separating goes through the warehouse.
For example if the person is separating in position...
I'm trying to save an information in my database with the following functions:
$sql = $request[0];
$query = $this->conn->prepare($sql);
$query->execute();
$ sql var_dump:
string(322) "INSERT INTO Fornecedor (razao_social, nome_fa...
I'm developing a project called Menu List with a MySQL database and in Java on NetBeans, with an added library of MySQL-Connector-Java. I want the names of the selected products, the quantity of products, and the total price of the Cardapio.j...
I have two tables:
comentarios
---id
---comentario
---usuario
---supermercado
---avaliacao
supermercado
---id
---nome
---endereco
---admin
I want to take the average rating of each supermarket and take the 3 supermarkets with the highest a...
How to update the values of a table, using values taken from another table:
UPDATE produto -- atualizar a tabela produto
SET produto.quant = SUM(entrada.quant) -- produto.quant será igual a soma da coluna quant da tabela entrada
WHERE pr...