Jump to content

SQL Query to bulk delete serial keys by ID


Recommended Posts

I'm using a serial key manager module and would like to bulk delete keys by ID.

I entered the following query in the SQL Query Manager:

DELETE FROM `ps_wk_serialkeymanagerproduct` WHERE `id_serial_product` BETWEEN 197932 AND 198031;

However, I understand the Query Manager only support SELECT statements, not DELETE.

Is there any way to perform SQL operations using the DELETE keyword? I saw online I could use phpMyAdmin but I'm not sure how I would do it or what permissions I'd need.

Thanks.

Link to comment
Share on other sites

  • 2 weeks later...

To access your website control panel, you usually need to contact the service provider. After entering the backend, there is usually phpMyAdmin. After entering, you can execute your SQL.
If you have any questions about your SQL, please contact your module developer as soon as possible.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...