Most voted "sql-update" questions
Update is an SQL statement that changes the data of one or more records in a table, as well as a subset of results, and can also be filtered by conditions.
Learn more…270 questions
Sort by count of
-
-1
votes1
answer105
viewsDELETE IN SQL WITH WHERE STATEMENT NO ID REQUIRED
I have ZIP table with a new OP field with DEL information to delete. When I perform the instruction: DELETE FROM cepdb.log_bairro where BAI_OPERACAO = 'del'; Returns: 2 Cannot delete or update a…
-
-1
votes1
answer583
viewsError while doing image update "Array to string Conversion"
I have a form where information is sent to the database, all are changed correctly except the image that is not changed. ed_cons_.php <?php //inicia a conexao com o banco include ("conexao.php");…
-
-1
votes1
answer309
viewsMysql update only one line field
In Myssql I have a table like this: I receive in a PHP via POST id of the table and which photo I must clean from the database: id= 1 foto = aaa.jpg With UPDATE need to leave the table like this:…
-
-1
votes2
answers701
viewsUpdate table of duplicate records with conditions
hello friends I have a table and I would like to update the records in order to take the NAMES that repeat and put as ACTIVE = 0 only which DATA_CADASTRO are old! table:…
-
-1
votes1
answer315
viewsProblem to edit an object in spring boot + Thymeleaf?
This is my controller: @GetMapping("/editpost/{id}") public ModelAndView editPost(@RequestParam(name="id")long id) { Post postFound = nb.findById(id).get(); ModelAndView mv = new…
-
-1
votes1
answer65
viewsUpdate between two tables with conditions
I have a question in my work regarding locating and replacing a certain field, updating it with a value of a search. I’ll give you an example: I have this table that has LOC_NUM_SUB and note in the…
-
-1
votes1
answer79
viewsPython - update() failure to merge dictionaries
Hello I searched and found that dictionaryA.update(dictionaryB) is able to join the two dictionaries together. I tested and it actually works. But in the little exercise program below, it does not…
-
-1
votes1
answer67
viewsUpdate with JOIN with 2 tables together with Select
Hello, I’m with the following query to perform in a database but locked in a situation, below follows the query, the error message and then the explanation. Excerpt from the Code USE BDTESTE GO…
-
-1
votes1
answer131
viewsUpdate the status of multiple ids at the same time Mysqli php mvc
Good morning! I need to "Pick up the selected Ids" and change their status to the option you choose in select status. Bulk editing, same value in the status field for all selected Ids. Models:…
-
-1
votes3
answers91
viewsEdit only one table row
I am trying to create an option to edit the information of a table I created using PHP and Mysql, I even managed to create the option and the data can be modified, the only problem is that if I…
-
-1
votes1
answer18
viewsProblem with update Trigger PLPGSQL
I have a Trigger for a stock audit, the Insert of it works, but the update no, or it changes nothing or changes all records with the same item code. How can I adjust this part of the Where of update…
postgresql function sql-update trigger plpgsqlasked 3 years, 6 months ago Camila Gabrielly Gonçalves 1 -
-2
votes3
answers133
viewsUpdate in database not working
Man update in the bank does not work, follows codes: php student. <form method="post" action="?acao=save&id_aluno=<?php echo $id; ?>"> <?php echo $pegaid; ?> <input…
-
-2
votes1
answer52
viewsHow to use MYSQL with Case or IF
This is with CASE that does not work, the idea is simple every day the training of the players is reset to 15, IF the player is VIP, that is to say "time VIP" LESS than the current date, he has only…
sql-updateasked 3 years, 6 months ago Marcos Júnior 23 -
-2
votes1
answer26
viewsUPDATE in two tables at the same time
I need to perform a Update in two tables at the same time, each of which contains two fields that will be changed. However, it is not working! Returns error in INNER Look how I thought: ID_ESTOQUE =…
-
-2
votes1
answer50
viewsUncomplicated update
Hello a good evening to all first, my doubt is the following... on my site I have a system of visits it works as follows if( there is no session visit){ $handle = "picks up the visit fields in the…
sql-updateasked 6 years, 11 months ago Lucas Prismo 11 -
-2
votes1
answer16
viewsUpdate records by blocks
Hi, I need to make a update in a field (called block) for each given amount of records. I have 100 records, for every 10, I must enter a (automatic) number in the field. The idea is to divide the…
-
-2
votes1
answer60
viewsI have this code, how to update in sql?
have tried $sql = " UPDATE biblioteca SET nome_usuario WHERE nome_usuario IN ( SELECT nome_usuario FROM ( SELECT nome_usuario, COUNT(id_usuario) FROM orders WHERE nome_usuario )" $sql = "UPDATE…
-
-2
votes1
answer23
viewsUpdate a given table field - SSMS V18
I’m filling a table with data that I pick up in a JSON, as shown in the image: When the markettype is 'place', does not have the correct information of 'Category' and 'Distance'. When the markettype…
-
-3
votes1
answer1134
viewsUPDATE in two tables
I’d like to make one update using a Inner Join. I tried this: UPDATE m SET m.rua = 'Rua Major Gote', b.desc_bairro = 'Centro', m.id_tipo = '', m.numero = '652', m.CEP = '38700001', m.cidade = 'Patos…
-
-3
votes1
answer693
viewsSeveral UPDATES in the Firebird database
I can create a method that performs several updates in the Firebird database? For example, I want to update the following record, but it would have to be one at a time, have to update otherwise?…