모바일,데스크탑 프로그램 개발

1. 날짜비교 - 현재보다 3일전 date_format, curdate() DATE_FORMAT(날짜, '%Y%m%d')>=DATE_FORMAT(CURDATE()-2, '%Y%m%d')

https://mydiamo.com Ultimate Encryption Solution for Open Source DBMS MyDiamo is a leading open source DBMS encryption solution for MySQL, MariaDB, Percona, and PostgreSQL. Supports both Windows and Linux OS. mydiamo.com

http://www.mysqltutorial.org/mysql-update-join/ MySQL UPDATE JOIN | Cross-Table Update in MySQL This tutorial shows you how to perform cross-table update by using MySQL UPDATE JOIN statement with INNER JOIN and LEFT JOIN. www.mysqltutorial.org MySQL UPDATE JOIN syntax We often use join clauses to query rows in a table that have (in the case of INNER JOIN) or may not have (in the case of LEFT JOI..

DELETE g5_shop_cart FROM g5_shop_cart LEFT JOIN g5_shop_order ON g5_shop_cart.od_id=g5_shop_order.od_id WHERE g5_shop_cart.od_id'' AND SUBSTR(g5_shop_order.od_time,1,10)