Questions tagged as 'sql-update'

Tagged questions
2
answers

Problem with UPDATE mysql

I have a problem executing an UPDATE command in my Database ... My table has 2 columns: -Column 1: link (PK) varchar -Column 2: statuz varchar I need to update only the "statuz" field in my table.    * change the value from "NEW" to "...
asked by 27.06.2015 / 09:00
2
answers

UPDATE only on last inserted rows

I'm importing some Excel spreadsheets via ETL into a relational database. The problem is that for me to be able to perform the relationship of the tables, I am using queries for the insertion of the foreign keys. But as the bank grows, these que...
asked by 11.11.2018 / 05:10
1
answer

Update of a single information in Laravel

I'm starting to work with Laravel and wanted to know if you can help me. I need to update a single value in the database, using 'name' in the where clause instead of id. This is for a situation of a real system that I need to migrate to Larav...
asked by 20.11.2018 / 22:02
1
answer

Change ZIP Code column inserting hyphen character in Firebird

I have a table of cities where I have zip codes. The data looks like this: 89620000 I would like to leave them like this: 89620-000 How can I do this in Firebird?     
asked by 20.12.2014 / 02:08
2
answers

Update only one character in a column - Oracle

I have a column, where it is written R. TEST, I just need to make a correction leaving for STREET. TEST, how to make this change in the Oracle database.     
asked by 18.07.2017 / 15:07
2
answers

Is it possible to perform an Update in this way?

I have two tables, the Impressoras table is where the equipment data, such as model, assets, etc., is stored. And I have the Impressora Local table where the location where the printer is located is stored, the client where it is c...
asked by 10.07.2017 / 16:09
1
answer

Update multiple records at once laravel

Hello, I have a table with the following fields: KEY, VALUE , ALIAS, CLIENT_ID . In a given system process I need to update the Key and Value. To update the append a record I have no problems, the problem is that when I need to change t...
asked by 15.09.2016 / 19:37
1
answer

Composite update

I have a table pessoas where, I have several fields referring to the person's registry, One of these fields is PES_NUMERO , which is nothing more than the code of the person in the system, well, I have another field called EST_N...
asked by 22.08.2016 / 21:43
1
answer

Problems with \ no update mysql

I have a field in a table that holds the path to a locally stored file. When I run the following command: UPDATE tabela1 set caminho = 'c:\logs\caminho.txt' where cod_tab = 1 it writes without the backslash. Therefore, it saves as follows:...
asked by 12.06.2016 / 07:03
1
answer

Update in database in Visual Studio

Could you tell me where the error is in this little bit of code I am creating for a budget program with a database with 4 tables (only the last cmd7 object is not accepted in the build): OleDbCommand cmd1 = new OleDbCommand("INSERT into Client...
asked by 19.11.2015 / 01:25