MySQL Forums
Forum List  »  Newbie

Re: Simple Delete Query
Posted by: Keith Larson
Date: April 22, 2014 07:12PM

DELETE FROM prefix_tablename WHERE created > 2013-04-20 00:00:00 AND section_id =1;


If you are unsure it would be wise to run a select first and ensure that it is everything you want to delete.

SELECT * FROM prefix_tablename WHERE created > 2013-04-20 00:00:00 AND section_id =1;

Just trying to help....

http://anothermysqldba.blogspot.com

Options: ReplyQuote


Subject
Written By
Posted
April 22, 2014 08:17AM
Re: Simple Delete Query
April 22, 2014 07:12PM
April 22, 2014 09:23PM
April 24, 2014 06:36AM
April 24, 2014 06:38AM
April 24, 2014 07:36AM
April 24, 2014 08:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.