Search
 
SCRIPT & CODE EXAMPLE
 

SQL

check records older than 10 days

SELECT * FROM photo WHERE DATE(date_created) < DATE_SUB(CURDATE(), INTERVAL 10 DAY);
Comment

PREVIOUS NEXT
Code Example
Sql :: sql get frist of month 
Sql :: mysql db dump restore max file size issue 
Sql :: Create a username nd password in MySql 
Sql :: codeigniter 3 get best-selling products 
Sql :: mysql table inspector command line 
Sql :: oracle rolling back 
Sql :: mysql default tls v1.3 ciphersuites 
Sql :: Inner join steps 
Sql :: Postgres: Update Boolean column with false if column contains null 
Sql :: group by join columns per table 
Sql :: sql create tablwe 
Sql :: mysql exception output 
Sql :: write sql query to show the details start from digit 
Sql :: Downloading snowsql for Linux 
Sql :: Which MySQL statement is used to delete data from a database 
Sql :: install package for sqlserver in asp.net core 
Sql :: drop tables from local table database postgres 
Sql :: Table aliases 
Sql :: mysql password reset 
Sql :: BigQuery define array varriable 
Sql :: lost connection to mysql 
Sql :: maximum number of tables in mysql 
Sql :: drop check command 
Sql :: sql alchemy escape ; in insert statement 
Sql :: Selecting data from table where sum of values in a column equal to the value in another column 
Sql :: how to enter psql shell 
Sql :: what is group function in sql 
Sql :: what is rownum in oracle 
Sql :: list databases in sql server 
Sql :: data structures in sql 
ADD CONTENT
Topic
Content
Source link
Name
2+7 =