Questions tagged as 'sql-update'

Tagged questions
1
answer

Problem with Trigger After Update with Internal Update in Mysql

I'm creating a trigger in mysql, the trigger is created but when I go to update the flag to test mysql it returns me this error ERROR 1442 (HY000): Can't update table 'aux_Batelada' in stored function/trigger because it is already used by st...
asked by 25.07.2018 / 22:48
2
answers

Oracle Update with Join - ORA-01779

Good morning, I'm trying to do an update on a column using information from another table using ORACLE. However, I'm getting the error "ORA-01779: Can not modify a column that maps a table not preserved by the key." Following script used:...
asked by 10.07.2018 / 15:45
0
answers

Trigger creates duplicate records

The "update" trigger in Mysql creates 8 records with each update. The first record is the old record, the next 7 are copies of the change. How do I leave only the old and the edited? I tried to put a UNIQUE key in the datetime of the "histo...
asked by 23.05.2018 / 09:00
1
answer

How to update a field in MongoDB

Considering the following structure: { "_id" : ObjectId("5ad69abb3630404194c80571"), "cnpj" : 2352345234523452, "razao_social" : "Lalala Ltda.", "fantasia" : " "aiufhdiua Ltda.", "dt_criacao" : ISODate("2018-04-18T01:09:15.076Z"), "usuarios" :...
asked by 19.04.2018 / 05:22
1
answer

Current version of Prestashop recommended for migration

I will migrate to a more current version of Prestashop. I need to use the modules for Safe Pag, Paid Market, Paypal and FK modules (or equivalent). What is the most current version where these modules are available for free? Thank you for you...
asked by 16.04.2018 / 19:53
1
answer

AngularJS / PHP / Javascript - I can not update the value of ng-model

First good evening. I have a simple table that is fed by a SQL database. I developed a button that aims to update the contents of the "ng-model" according to what you type in a simple form. The table is updated through an http.post request. The...
asked by 18.04.2018 / 04:43
0
answers

Update on two tables using php mysql stopped working

I'm having problems running the update on two tables ... It worked until recently, but it updated the XAMMP that I use for testing and it just stopped! Is there a new way to run the update? <?php // RECEBENDO OS DADOS PREENCHIDOS DO FORMUL...
asked by 20.03.2018 / 19:12
0
answers

MySql UPDATE INNER JOIN Save Results Before Finishing

I have a mysql query in progress, status: seding data, and I want to stop the process without losing data already acquired by INNER JOIN, present in the cache. It is as if it were a command to during the processing of the Query to record in the...
asked by 14.02.2018 / 18:11
0
answers

PHP and MySQL - UPDATE error

On my client's PHP-based site that uses MySQL, users should populate employee evaluation data. But in two moments, I have received notifications from users who will continue the reviews and have their data "lost". In this case of continuing eval...
asked by 05.02.2018 / 12:24
1
answer

Synchronize MySQL database with XLS

The situation is as follows. I have a MYSQL database and an XLS file on an FTP server The code below downloads XLS to read and UPDATE from the database from the XLS data. The problem is that it only updates the existing data, I need to check...
asked by 06.01.2018 / 00:01