Questions tagged as 'sql-update'

Tagged questions
2
answers

update sql relating a column with external value

Good morning, I'm having a hard time doing an SQL Server update. I have the following situation: Table 1 ID Codigo Table 2 ID Nome And I have an excel file like this: Excel Codigo Nome I need to update the Name colum...
asked by 25.09.2018 / 14:40
1
answer

Create a trigger to trigger whenever a field is edited mysql

Good colleagues, I have a problem that I still can not solve. I want to create a trigger that whenever the column of quantity of product undergoes a update it triggers an action for another table, to allow the user to know that a certain product...
asked by 31.07.2018 / 12:12
1
answer

Update does not find what was typed in the inputs

I have a system where you can change the information of a record through an editing form, but this edition is not being saved. HTML <?php $lnk = mysqli_connect('localhost','root','') or die(mysql_error());...
asked by 25.05.2018 / 15:36
1
answer

How do you use the UPDATE command more than once? [duplicate]

I can not use the UPDATE command more than once. 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: Int att,index; Private vo...
asked by 23.05.2018 / 16:03
1
answer

Update does not generate errors but does not update table

I have a problem, and I come to ask for help. This one has this code that refers to a complete customer registration form for my site Insert done, works perfectly and writes information to database Already the update when I edit one of these c...
asked by 16.05.2018 / 15:05
1
answer

Performing UPDATE in ORACLE using FROM

How to UPDATE in Oracle records without using a IN clause to change bulk data? This way: UPDATE TABELA1 SET DADO = DADO FROM TABELA2 WHERE TABELA1.CODIGO = TABELA2.CODIGO; Currently it forces me to report a IN c...
asked by 12.01.2018 / 21:15
1
answer

Update table with the highest value of another table in MySQL

I have a table called officials , with the following fields and values: nome salário a 10 b 100 c 30 d 40 I have a second table called official_more_caro , with the same fields as abov...
asked by 14.12.2017 / 01:14
1
answer

How to update mysqli database table with UPDATE?

I am creating a data listing system, and I created a data change page, with 6 fields, name, experience, email, phone, city and bio. but my function does not update the fields. The data arrives in function change_data () but does not update in...
asked by 08.11.2017 / 13:28
2
answers

If there is data in mysql make a PHP / MySQL update

Well, I suppose this question is recurrent. I even tried some alternatives but they did not work. I have a Screen where I record Service Orders with the Client and PC data. It turns out that. I am filling 2 Tables simultaneously. In the...
asked by 15.10.2017 / 18:22
3
answers

Update in the values of the CD_SETOR column in all the tables found with the column

Using select SELECT * FROM DBA_TAB_COLUMNS WHERE column_name like 'CD_SETOR' I get many tables with different owner with the same CD_SETOR. EX: Owner Tables Column Type 210 MVINTEGRA INTEGR...
asked by 21.06.2017 / 22:37