database cleaning - customer_visitor

[callam_kidsaw]

Hello,

I have the following table in my magento database sitting at 350mb called:

customer_visitor 

What is the SQL command to delete all the visits before September 2019? I don't want to truncate the whole table.

[Vimal Kumar · Accepted solution]

Hi @callam_kidsaw,

You can delete from table using following query.
 

To get the result to verify.

SELECT * FROM FROM customer_visitor WHERE last_visit_at < '2019-09-01';

then you can delete if data is correct.

DELETE FROM customer_visitor WHERE last_visit_at < '2019-09-01';

I hope it will help you!