Category: MySQL
-
Remove new duplicates from any sql table
If you want to remove older rows, use the following:
-
How to update customer password in Magento 2 database?
Please note that if SPJ9WIp7 is the salt and User’s password is 7qLzX33ETxYE, the following will be your query: 7615 is the customer id
-
How to export multiple selected tables in PMA phpmyadmin (but not all tables)
Click on export, and choose “custom” export method. Lets say you want to export first 20 tables only. Open chrome or browser console [ctrl+shift+j], enter the following: For next 20, use 20,50 as arguments in slice function used above.
-
Where are customizer settings stored in db for wordpress theme?
How to clone customizer settings in child theme from parent theme? The customizer data is stored in table wp_options under option_name theme_mods_THEME-NAME you can view all such settings via the following query: In some cases, you just want to use parent theme’s settings in newly added child theme. If that is your case too, use…
-
Fixing broken “screen options” in wordpress site
So probably you chose “Number of items per page” as 1000 or 200 and now the page doesnt load anymore because your database ran out of memory. If that is the case, run the above query on phpmysql or any other way, edit the numbers and fixed!
-
How to solve MySQL server gone away error Maria Db update on cPanel and WHM?
This is related to new MariaDb upgrade from 10.1.41 to 10.1.42 and also for servers which were updated from 10.2.27 to 10.2.28 Go to solution ( Special Thanks to @Valetia ) You will see errors in following formats/messages: No file or input found MySQL Server has gone away Connection to MySQL Server failed sqlstate[hy000]: general…
-
How to change attribute dropdown type to multi-select in Magento 2?
Short Answer: Not possible via Magento2 Admin Backend. Solution: You need to update eav_attribute table and edit information about backend_source, frontend_input etc. Simple query for that is: Replace YOUR_ATTRIBUTE_ID_INTEGER with your attribute_id like 355 Reference: https://stackoverflow.com/a/57701845/2229148
-
How to wipe all the tables and data in MySQL? Clean whole database
Will not work via phpmyadmin or any script. this has to be run in cmd/terminal Quick Command Source: https://gist.github.com/harshvardhanmalpani/e670a8de7aa81673364dd48f125cb9ac
-
How to reverse the ids in a mysql table column without breaking primary key constraint?
Let me explain the problem scenario: Let us assume we have a table with 4 columns in it out of which 1 is PRIMARY column and rest 3 contain some data. What we want to do is to reverse the primary key IDs for that data keeping the rest of data intact. It is like…