loading icon
  • W3codegenerator W3codeGenerator
    • Code Generators
    • Code Snippets
    • Articles
    • Online Editor
Search by Queries/Bugs/Errors
Skip to main content

SQL query to delete records older than 6 months

  • DELETE FROM Table1 WHERE dateAdded < DATEADD(MONTH, -6, GETDATE())
  • Back to code snippet queries related sql

Bootstrap Cmd CodeIgniter Css Drupal Git Html Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress
Random Code Snippet Queries: Sql
  • Insert multiple rows in a single MySQL query
  • How to check column exists or not in table using MySQL
  • SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1
  • Create column after a column in existing table using query in MySQL
  • How to retrieve data from two tables with one SQL statement
  • How to show database tables in mysql using command line
  • 1553 Cannot drop index 'posts_user_id_foreign': needed in a foreign key constraint
  • Drop foreign id column (user_id) in MySQL
  • SQL query to delete all rows older than 30 days
  • Database connection using mySQLi with object-oriented
  • How to check the MySQL version
  • How to create a new table from existing table in SQL
  • Get data in random order with limit from table using mysql
  • Change existing MySQL table column id to autoincrement
  • Cannot drop index 'fk_role_id': needed in a foreign key constraint
  • Get create table Query from existing table in phpMyAdmin
Modal title
Share on social media
About w3codegenerator

W3codegenerator is the platform where webdevelopers can generate html, bootstrap, htaccess and others code. We also provide articles and tutorials to solve coding problems in real world.

Site links
  • Contact Us
  • Privacy policy
  • About us
Social links
  • Facebook
  • Twitter
  • LinkedIn

Copyright © w3codegenerator.com

All Rights Reserved.