在customers表中，查询同年同月同日注册的顾客信息

在customers表中，查询同年同月同日注册的顾客信息，包括customerr_id,name,gender,email,registration_date,nickname

SELECT customerr_id, name, gender, email, registration_date, nickname
FROM customers a  inner join customers b
on    a.registration_date=b.registration_date where a.customer_id!=b.customer_id

SELECT customerr_id, name, gender, email, registration_date, nickname
FROM customers
WHERE YEAR(registration_date) = YEAR(CURRENT_DATE())
AND MONTH(registration_date) = MONTH(CURRENT_DATE())
AND DAY(registration_date) = DAY(CURRENT_DATE());

这个查询会返回在当前日期注册的顾客信息。如果需要查询不同的日期，可以将CURRENT_DATE()替换为指定日期，例如'2023-05-07'
如果对你有帮助，请给我一个采纳，谢谢啦