Questions tagged as 'delete'

Tagged questions
1
answer

How to remove duplicate records in MySQL with WHERE condition

My address book table has many duplicate addresses for each client. Note in the screenshot below that I have many duplicate zip codes for the same client with ID 12. Ineedtoremoveduplicateaddresseswherepostcodeandparent_idaregreaterthan1andk...
asked by 24.09.2018 / 14:40
1
answer

How to delete objects from a list?

I have the following code: using (Context contexto = new Context()) { List<Cliente> listCliente = contexto.Cliente.Where(x => x.Status == 0).ToList(); } How do I delete this result from the database? Remembering that I have num...
asked by 13.06.2017 / 15:03
3
answers

Ask before deleting bank data

I have this code: <?php if ($result = $mysqli->query("SELECT * FROM usuario ORDER BY id")) { if ($result->num_rows > 0) { echo "<table border='1' cellpadding='5' cellspacing=0 style=border-collapse:...
asked by 23.09.2014 / 20:22
1
answer

How to remove a specific character from some specific strings inside a list in Python?

I have an example list: ['#[Header]', '#Application Name\tLCsolution', '#Version\t1.24'] I'd like to know how to remove a specific character, such as # of all elements in the list, or, if I prefer, only some elements, such as [0:1...
asked by 16.06.2018 / 20:32
1
answer

Do rows delete in several tables dynamically, in Postgres

I need to do a delete to clean the database automatically on tables that are within different schemas, the "public" and "cine"; I have the following query that returns me SELECT concat('"',table_schema,'"', '.', '"',table_name, '"') as...
asked by 23.03.2018 / 17:57
1
answer

See changes (delete) in the vb.net grid

Hello, I would like you to help me with the following .. I have a form that does a search for a code with several grids and a button, this button makes a lot of changes in the various grids but I also want to delete some lines with one delete qu...
asked by 10.12.2014 / 13:23
3
answers

Delete duplicate table record in PostgreSql

Situation I have now performed a two-time process where it should be processed only once. So my table was populated twice with the same data. tb_kardex cd_kardex | cd_item tb_kardex | 1 | 45875 | | 2 | 45876 | | 3 | 45877 | | 4 | 45875 | |...
asked by 09.12.2015 / 18:18
1
answer

c # delete drawstring in picturebox

I have a pictureBox where the user at each click of the mouse inserts a text on top of an image in a pictureBox. It inserts several texts in several points of the image, the inserted text gets picked up from checkboxes. Using this code pri...
asked by 02.08.2017 / 18:45
2
answers

Error in DELETE method, to delete a data from a table

I'm trying to make a method to delete an entry from a table with Java and jsp , but it's giving 405 error. I'll append the codes. ProductDao.java: public void remove(Produto produto) { em.getTransaction().begin(); em.remove(bu...
asked by 20.06.2017 / 21:59
1
answer

Delete a specific Image from a File

I am currently working on a new project, using Codeigniter, it is my first experience and I do not find great help, I want the user to delete a photo chosen by him from his folder, The controller: ' public function delete() { delete...
asked by 08.06.2018 / 12:58