Questions tagged as 'delete'

4
answers

Delete thousands of records from a table

I have a table, for example, pessoa , and I would like to all people over 40 , with the script below I do this: > DELETE FROM pessoa WHERE pessoa.idade > 40; The problem that there is more than 2 million records in the table ,...
asked by 14.12.2016 / 19:42
2
answers

When should I inactivate or delete a record? Good database practices

I have the following question: When should I inactivate a record? When should I delete a record? In case you would like a good practice tip, on which tables does I make a STATUS column? If the tables have this STATUS column I will do an...
asked by 27.10.2015 / 23:14
1
answer

Receive parameter in delete request

I am trying to pass a parameter to my DELETE request, I tried to do the following: Use the same way I use in GET (where it works normal). app.delete('/contatos', function(req, res){ var obj = req.body; console.log(obj); }); Howev...
asked by 01.09.2015 / 04:51
2
answers

Deletion of related data - Entity Framework and C #

Hello, Using the same structure I've been presenting here for some time now, I've come to you for help now to delete the related data. Follow the entities .. public class Artista { public int ArtistaId { get; set; } public string No...
asked by 13.02.2016 / 16:06
1
answer

How to reload the page after the message close using Hubspot Messenger (). run ()?

I'm doing an MVC app and need to do a reload after the message close (successful or not). How can I do this? CodePen for testing: link HTML: <button class="btn btn-danger deleteButton" id="btnAction" data-url="https://jsonplacehol...
asked by 09.01.2017 / 18:05
1
answer

mysql Delete all records in a table except the first one

Can someone tell me where I'm going wrong? or is it possible to do this? I wrote the query like this: DELETE FROM reservas WHERE ID NOT IN (SELECT ID,IDORIGEM FROM reservas WHERE ID='387' and IDORIGEM='387'); The id field keeps always th...
asked by 30.06.2016 / 21:52
2
answers

Delete character in a certain position?

How do I delete a particular character in a particular position in the shell? I've tried with sed , but I can not put the position too, just the default. ",45123","B23142DHAS675" What I wanted was to delete the , that is in...
asked by 30.04.2014 / 21:24
2
answers

C ++ - Use delete on objects allocated without new?

Hello, I have always used object-deletion in my c ++ projects with Qt since when I dynamically allocate them with the new operator, but in my last project that was relatively large, I began to feel a difference of performance according to its...
asked by 14.09.2016 / 17:15
2
answers

Angular - delete $ scope.categoria_nova;

My delete does not work when registering a new category: The form does not clear the fields, what can it be? JS: app.controller('categoriasCtrl', function ($scope, $http) { $scope.categorias = [ {id: 10, nome: 'Categoria teste 2', at...
asked by 03.12.2015 / 14:40
4
answers

PostgreSQL - Remove tuple referenced by another table

I have a problem that I did not find anything on Google (maybe I did not know how to ask him) Imagine the following: I have 11 tables, one call tbl_pai and 10 other calls tbl_filha1 , tbl_filha2 , tbl_fila / em>. / li>...
asked by 27.01.2016 / 14:05