Tag: sql

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…

May 6, 2021
How to disable products in Magento2 which dont have any gallery image?

It is SQL query Assumption: value=2 means disable and value=1 means enable attribute_id=96 means “status” attribute References: https://gist.github.com/tegansnyder/8464261#gistcomment-2910808 https://magento.stackexchange.com/a/83033/32283

August 22, 2019
Some of the most important SQL commands.

SQL, Structured Query Language, is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and it helps maintain the integrity of databases, regardless of size. Most of the actions you need to perform on a database are done with SQL statements. SQL commands are…

January 24, 2019
Simple joining of data from two different tables on basis of a common key

August 7, 2018
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry Magento 2

May 29, 2018