Posts by Sabrina T. • 157 points
13 posts
-
2
votes1
answer51
viewsQ: Delete duplicate rows in a table
I used the following SELECT to find the repeated values: SELECT nome, Count(nome) FROM projeto GROUP BY nome HAVING Count(nome)>1 Now I need to delete everything that is repeated and leave only…
-
0
votes2
answers53
viewsA: JSON does not return Mysql database data
I discovered that the problem was being caused by the special characters of the data. I put utf8_encode in each line of the vector and managed to return the values, although the special characters…
-
0
votes2
answers53
viewsQ: JSON does not return Mysql database data
I made a very simple application to search for projects by state in the database. However, JSON does not show any errors, but also does not return anything. I imagine the problem may be in GET. Do…
-
0
votes2
answers49
viewsA: UPDATE only in the last inserted rows
I managed to solve by putting a simple condition in my UPDATE. In my case it worked because the fields I want to update are always null. UPDATE estrutura q SET q.id_horizonte = (SELECT…
-
1
votes2
answers49
viewsQ: UPDATE only in the last inserted rows
I’m importing some Excel spreadsheets via ETL into a relational database. The problem is that in order for me to achieve the relationship of the tables, I am using queries for the insertion of…
-
1
votes1
answer303
viewsQ: Problems importing data with Microsoft Excel Input
I’m importing several spreadsheets into a database, but some of them are having input problems. I’ve even tried to transform the format and use CSV File Input, but the problem remains the same. The…
-
1
votes1
answer44
viewsQ: Select a list of values and from that list, select the lowest value
I want to select the last 10 inserts of a table and among these 10, return the lowest value. It is possible to do this in a single query? Selecting the last 10 values: SELECT id_relevo FROM relevo…
-
3
votes1
answer72
viewsQ: Condition of a query with an under-consumption
I need to update the last 110 table records relevo, but my problem lies in the current WHERE. I’m doing it this way: UPDATE relevo SET id_projeto = 157 WHERE id_relevo = (SELECT id_relevo FROM…
-
0
votes1
answer287
viewsQ: Insertion of foreign keys by the kettle
I need to load some data that are in spreadsheets in a relational database, but I have been facing some challenges regarding the insertion of foreign keys. In these images you can see that I first…
-
-1
votes1
answer763
viewsQ: PHP files do not update CSS and Javascript changes
This had already happened to me before, but I solved by giving a CTRL + F5. Now NOTHING helps. I’ve restarted wamp several times, even restarted the computer and nothing. The funny thing is that it…
-
1
votes3
answers1298
viewsA: Perform table insertion with foreign key
The property insertion form: <body> <h1> Nova propriedade</h1> <form action="../controle/controle_propriedade.php" method="post"> Nome: <br/> <input name="nome"…
-
1
votes3
answers1298
viewsA: Perform table insertion with foreign key
Propriedadedao class include_once 'acesso_bd/conexao_bd.php'; class PropriedadeDAO { function inserirPropriedadeBD($propriedade) { $nome = $propriedade->getNome(); $endereco =…
-
4
votes3
answers1298
viewsQ: Perform table insertion with foreign key
include_once 'acesso_bd/conexao_bd.php'; class PropriedadeDAO { function inserirPropriedadeBD($propriedade) { $nome = $propriedade->getNome(); $endereco = $propriedade->getEndereco();…