MySQL command - Showing/Cleaning guest carts (id_customer = 0)

[JSSSX]

Hello, 

 

I am often using this command to delete the unused carts from non customers : 

DELETE FROM `ps_cart` WHERE `id_customer` = 0

 

Always working fine.

 

 

Anyway I wanted to show the status of this table/column before cleaning but using : 

SHOW TABLE STATUS FROM `ps_cart` WHERE `id_customer` = 0

 

It drops me #1054 - Unknown column 'id_customer' in 'where clause'

 

What would be the correct syntax to show id_customer status using SHOW TABLE STATUS ?

 

 

Thanks.

Edited April 23, 2016 by JSSSX (see edit history)

[shokinro]

Show table status is used to display the status of tables, it is not used to display data of a specific table.

 

SHOW TABLE STATUS FROM YourStoreDBName like '%cart%';

 

If you want to show the data of the cart table, please use

SELECT  * FROM ps_cart  WHERE id_customer = 0

[JSSSX]

Thank you for the quick reply.

 

Regards,

[shokinro]

my pleasure, hope it helped.