Questions tagged as 'sql-update'

Tagged questions
1
answer

UPDATE, field with placeholder query failed to execute

Follow the code: $campo = $_POST['campo']; $valor = $_POST['valor']; $id = $_POST['id']; $mysqli = new mysqli("localhost","root","","tabela"); mysqli_set_charset($mysqli,"utf8"); $consulta = $mysqli -&g...
asked by 20.01.2015 / 01:38
1
answer

Change MySQL column information with UPDATE

In summary through PHP below I can send the specific information already registered in the column in the BD, but in addition to just "emitting" the data there, I would like a function that would change such information without changing the page...
asked by 26.12.2014 / 18:36
2
answers

SELECT AND UPDATE - Undefined index when submitting form

Hello I am building a content manager and I have a page where I return the results of the chosen country, so that I can then update each field. By choosing each country on the Paises.php page, I send the respective parameter to the edit pa...
asked by 11.09.2017 / 19:46
1
answer

split 1 column into 2 on sql server giving update

I use SQL Server 2012 I have the following problem, in a table there are records of municipalities and two respective UFs, however the need arises to divide this column into two municipalities and one UF, but the data is like this: CANDÓI-P...
asked by 12.07.2017 / 22:07
2
answers

UPDATE on multiple tables with the same column?

Let's imagine a scenario where I need to give a update in 10 different tables in the same column in all of them updating a given data, will the syntax below work? UPDATE tab1, tab2, tab3... SET id_usuario = 'novo id' WHERE id_usuario =...
asked by 12.01.2017 / 12:32
1
answer

How to write the value with decimals before the point in the sql server?

I have a field in the bank with this format TESTE numeric(8, 3) I want to record this form. UPDATE TB_PLANO_CONTAS SET TESTE = 001.000 WHERE IDPLANOCONTAS = 63 The result looks like this: 1,000 UPDATE TB_PLANO_CONTAS SET TE...
asked by 13.11.2015 / 18:18
1
answer

How to keep data updated in two tables?

There are two tables that should be kept up to date in different banks, "User" database "DB1" and "User" from the "DB2". In this case, it would be the "password" field to be updated. I have a Trigger BEFORE UPDATE in the database "BD1" that is f...
asked by 13.03.2015 / 21:55
1
answer

The implicit conversion of the nvarchar data type into varbinary (max) is not allowed. Use the CONVERT function to perform this query

Follow the code below: byte[] image1 = ConvertTo.Bytes(Request.Files[0]); byte[] image2 = null; ctx .Users .Where(x => x.Id == 1) .Update(x => new User() { ImageByte1 = image1, ImageByte2 = image2 }); I use this here: link...
asked by 11.11.2017 / 00:18
0
answers

Update within a mysql function

I have to do a process to perform an update on a given field in a table. I created a function in mysql. But within this function would need to perform an update, plus the function does not accept uptade would have any way to perform this proc...
asked by 14.06.2018 / 03:38
1
answer

Update in Database by C # [closed]

I'm trying to do an update in my database through Visual Studio (C #), however the update is not being performed I do not know why. Table Script ( sql developer ): CREATE TABLE Login ( Cod_login NUMBER(8) NOT NULL, Usuario VARC...
asked by 10.10.2016 / 20:32