Questions tagged as 'sql-update'

Tagged questions
1
answer

Hide two div from form in php

This is the code you had: <?php $servername = "xxx.xxx.x.xx"; $username = "xxxxxx"; $password = "xxxxxxxx"; $dbname = "xxxxxxxxx"; $conn = new mysqli($servername, $username, $password, $dbname); $conn->set_charset('utf8'); $data =...
asked by 04.01.2018 / 01:46
1
answer

Create trigger after update in the table itself and in another

First I have a table: create table alecrim( id_alecrim int not null auto_increment, sem_epi int not null unique, p1 smallint, p2 smallint, p3 smallint, p4 smallint, p5 smallint, p6 smallint, p7 smallint, p8 smallint, p9 smallint, totOvos i...
asked by 01.01.2018 / 14:28
1
answer

PostgreSQL Update

I have a question, a customer informed that there was an error in the registration of his products, and the employees registered the cost price as the price and vice versa. Would I have to run an update from PostgreSQL , changing cost prices...
asked by 20.12.2017 / 05:30
1
answer

Update Multiple Columns

I have the following situation, I need to update the SB1300 table in the B1_DESC and B1_CODBAR fields for several lines. The where will be B1_XCODORI Can I do the same query?     
asked by 06.12.2017 / 14:47
0
answers

How do I change only one field

When I change a data in a table, it changes all other fields: code:<?phpif($_SERVER['REQUEST_METHOD']=='POST'){$nome_produto=isset($_POST['nome_produto'])?$_POST['nome_produto']:'';$quantidade=isset($_POST['quantidade'])?$_POST['quantidad...
asked by 20.11.2017 / 19:17
1
answer

Update through another table - Mysql

I have the following problem: I have a rev_tasks table that contains id as a key, and a second rev_reviews table and has a foreign key task_id , pointing to the task, and I have a ( revised ) field review has been revised or not. In rev_...
asked by 16.11.2017 / 13:15
1
answer

update on laravel

Good afternoon everyone! I created the form, which will send to the "update" method of laravel public function update(Request $r, Voluntarios $vol) { $up = $vol->update($r->all()); var_dump($up); } But it returns fa...
asked by 18.11.2017 / 19:18
0
answers

Updating the database

There is an error in the family composition, which says:    Undefined variable: compositionFamily The family composition code is this: $composicaoFamiliar = DB::table('membro_familiar')->insertGetId([ 'id_identificacao_usuario'...
asked by 19.10.2017 / 14:56
0
answers

Call to a member function method () on string

I'm using CodeIgniter and, when trying to do a search in my database to see if a given line actually exists, it displays the Call to a member function checarId() on string error. Here is the code for the functions that return this error:...
asked by 07.10.2017 / 21:26
1
answer

Run SQL Server UPDATE error

Running the update statement below is experiencing the following error. What can it be?    Msg 116, Level 16, State 1, Line 3   Only one expression can be specified in the select list when the subquery is not entered with EXISTS UPDATE Est...
asked by 13.10.2017 / 19:20