Questions tagged as 'sql-update'

Tagged questions
1
answer

How to insert this text in PostgreSQL?

I'm using a Delphi query and I need to insert the text below into a text type field {\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fswiss\fprq2\fcharset0 Calibri;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Tahoma;}} {\colortbl ;\re...
asked by 27.06.2018 / 23:32
1
answer

query update error

The $query1 and $query2 work, but the $query1a update is not set, does anyone know if it is a syntax error? $conexao = mysqli_connect('localhost','rr','4ai','rr') or die('Erro ao conectar ao banco de dados'); $query1 = "...
asked by 21.05.2018 / 15:37
2
answers

Update or insert with data from another table

I have this SQL command to update the REQUISICOES table with the data in the REQUISICOES_ATUALIZA table. Use as a key to update the field number_requisition, but I need that if I do not find correspondencia in the...
asked by 30.05.2018 / 17:24
2
answers

Unsupported update form

I have a form already filled with two extra inputs only for the user to edit the information already registered and add the two new ones. However, although%% of "saved successfully" appears, when I check with the bank, the information has not...
asked by 25.01.2018 / 17:42
3
answers

Doubt - Update SQL Server 2012

When the update below is run for the first time, the field exits correctly the way I want it as below, but if I run it again, it comes out that way. What I want is that regardless of how many times the script runs, do not duplicate the month or...
asked by 16.10.2017 / 16:07
1
answer

Update with select CTE Error

I'm having a hard time performing an update with select CTE. I want to refresh the taridinclusao field. Below is the query and just below is the update that I tried to perform, however, the following error occurs: "The 'historical' derived table...
asked by 27.09.2017 / 18:54
2
answers

How to compare in update

The main code is this: $dbconn = mysqli_connect($servername, $username, $password, $dbname)or die("Failed to connect to database:" . mysqli_error($dbconn)); $query = "SELECT id_medico as txtid, nome as txtNome, email as txtEmail, telemovel as...
asked by 02.07.2017 / 16:08
1
answer

UPDATE on two PHP tables

In my database I have a table called register id_cadastro username_user email_user age_user sobre_user fb_user tt_user in_user avatar_user These are the information I use for login. But after registering in this table...
asked by 12.07.2017 / 03:59
1
answer

Add point ('.') after 3rd character

I have a registry with the original product code, however I need to put one. (dot) after the 3rd character. Original code : 2022027 How should it be : 202.2027 The table structure follows: id nome descricao aplicacao i...
asked by 15.04.2016 / 20:00
1
answer

Send a value to the modal

I have a table with several employees and it counts the plate of each hum.   I created a modal that when the manager clicks on the employee's name is called a modal where you can enter the number of the plate.   Reason: there are situations...
asked by 20.05.2016 / 23:44