Questions tagged as 'sql-update'

Tagged questions
1
answer

Update with SET giving error

I have several UPDATE with pretty much the same code as this: UPDATE cliente SET Email = '[email protected]' WHERE idCliente = 0000; But some give this error:    Data truncation: Data too long for column 'Email' at...
asked by 10.08.2018 / 03:30
1
answer

Return values Select Multiple

Okay with all of you, I hope so. I have a question and I can not get on with my code. So let's go I have a multiple sign-up screen with the following data: <select class="form-control " id="restriction_details" name="restriction_detai...
asked by 28.10.2018 / 00:41
0
answers

Refresh field after insert

I'm trying to create a trigger to update a value after insertion, or before it works. I have the following table: test Remembering that the date field type is timestamp and the default value is CURRENT_TIMESTAMP id | da...
asked by 22.10.2018 / 20:57
1
answer

How do I set only one column row in which all values in this column are the same?

I'm trying to set the column ocupado only one line at a time, something like: update suite set ocupado = 'S' where tipo = 'i'; But this statement changes all rows in column ocupado where tipo is i , and that's not...
asked by 24.10.2018 / 17:36
0
answers

Miscellaneous Update's from a select RAND

UPDATE 'tabela' SET 'Relacionar_A' = (SELECT 'Relacionar_A' FROM 'tabela' WHERE 'Relacionar_A'='' ORDER BY RAND() LIMIT 2) I can only do% single , only 1 record from update . What I would like - and that I did not get a look for (pro...
asked by 07.08.2018 / 02:01
0
answers

How to properly update php

Hello, I am doing an administrative panel where the administrator can edit the Name, User and Email, but he does not perform the UPDATE in the database but in the message he says that the update has been followed by the Update code. <?php...
asked by 28.08.2018 / 03:37
1
answer

UPDATE problem and WHERE clause with two conditions

After much research on the internet without a solution, I turn to the "college students" on duty! I have two tables: contract (primary key) and contacts. The second being linked to the first. I set the records of the first one and select change...
asked by 11.06.2018 / 15:18
0
answers

Update Error Oledb C # [closed]

I can not use the UPDATE command more than once. ( link ) ( link ) ( link ) For example, when I perform the update at id 43, that's fine. But when I try to finish 44, it does not finish, but the 43 that gets the update .. Code:...
asked by 20.05.2018 / 23:19
1
answer

Update the rest of a table from the data contained in a row

The following figure explains well what I want to try (and what I tried to do but it did not work): That is, I need to update some rows of a table with the same data contained in a row (specifically the columns bankId, proj_day and liq_...
asked by 16.01.2018 / 01:36
1
answer

Record editing form does not change

On one page I have a material registration form, in another I have a table that shows all the materials registered with a button to change the information about a material and this button opens a third page with the same form of the first one on...
asked by 30.01.2018 / 14:00