GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Tech Upoad .csv file to MySQL DB and collate data?

sarettah · 06-09-2022, 12:36 PM

Select title, sum(amount) to total_amount from tablename where invoice_date>=date_sub(curdate(), INTERVAL 1 YEAR) group by title

.

06-09-2022, 12:36 PM
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,055	Select title, sum(amount) to total_amount from tablename where invoice_date>=date_sub(curdate(), INTERVAL 1 YEAR) group by title . __________________ All cookies cleared!