cwestray Posted June 24 Share Posted June 24 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 More sharing options...
Prestashop Addict Posted June 24 Share Posted June 24 In phpMyAdmin click on database and SQL tab enter your query and Execute button Link to comment Share on other sites More sharing options...
ZHSoft Posted July 4 Share Posted July 4 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now