Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select row from mysql where date more than 30 days

mysql> delete from DemoTable where UserMessageSentDate < now() - interval 30 DAY;
Query OK, 3 rows affected (0.11 sec)
Comment

PREVIOUS NEXT
Code Example
Sql :: ubuntu connect to mssql database 
Sql :: start mysql 
Sql :: SQL Server - Count number of times a specific character appears in a string 
Sql :: sql identity column reset 
Sql :: permission denied postgres copy csv command line 
Sql :: sqlite woth cmake 
Sql :: SQL COUNT() with DISTINCT 
Sql :: sql merge 
Sql :: how to connect to xampp sql server on windows cmd 
Sql :: mysql add column after another 
Sql :: mysql separator 
Sql :: how to find lowest in sql 
Sql :: drop row pgadmin 
Sql :: sql server locks 
Sql :: oracle nextval insert 
Sql :: current date sql 
Sql :: delete join select from one table based on multiple values 
Sql :: if else in postgresql 
Sql :: list of all table names in sql server databse 
Sql :: oracle pagination query offset 
Sql :: sqlite autoincrement 
Sql :: modify column name in sql 
Sql :: joomla execute raw sql 
Sql :: connect mysql command line 
Sql :: what is delimiter in mysql 
Sql :: sql server convert date to weekday 
Sql :: oracle difference between two dates in years 
Sql :: sum sqlalchemy 
Sql :: csv into data postgres 
Sql :: primary key multiple colums 
ADD CONTENT
Topic
Content
Source link
Name
2+8 =