Delete multiple rows with the same value for a field

I'm making an app for Android Devices in which I have to use SQLite.

I have the table Actions with fields Id, IdEvento, IdAccion, Activa.

I want to DELETE every row in the table Actions WHERE IdAccion = X

How can I do? If I do DELETE FROM Actions WHERE Id = X will it delete every row or just the first one that has that value for that field?

Answers


The query you provided will delete all the rows with Id = X.

You can also delete just one, the query for that is:

DELETE FROM Actions WHERE Id = X LIMIT 1

Need Your Help

g++ with python.h, how to compile

c++ python makefile

I compile one test code with g++ without any issue.

Problem creating SSRS report subscriptions

sql-server-2008 connection-string ssrs-2008

I am not able to create subscriptions for SSRS reports as it give the following error

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.