Help with syntax error

[TwistAndShout]

Hello,

I am trying to erase all products from a clone of my shop with this command :

DELETE FROM wp_posts WHERE post_type = 'product';

I identify my post table as this one :

8nSUmyx27_b2s_posts

So I send this command :

DELETE FROM 8nSUmyx27_b2s_posts WHERE post_type = 'product';

It fails, the system answers :

1064 - Syntax error close to 'WHERE post_type = 'product'' at line 1

Error Syntax SQL.png

Shared from Screencast.com

www.screencast.com

I looked everywhere, I can't find what the error is. Any idea anyone ?

Thanks in advanced.

 

[cPRex]

Hey there! I'm not sure there will be a good way to answer this for you as this isn't related to any cPanel tools on the machine. One would need to be familiar with the database and table structure to see why that error is happening. You might want to try running some "select" commands to see if you can query the data you are expecting to remove first, before trying the removal with "delete from"