Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 64463

Questions related to Magento's MySQL database, for example, the table schema, plain SQL queries or database configuration. For questions about the Magento database access layer, use other tags, like: eav, model, resource-model, collections, install-script. For questions about SQL queries in particular, the SQL tag is appropriate too.

0 votes

I am facing an database rollback issues in Magento 2.3

You are facing this issue because this is actually not a table. It is a view. So before rollback when you clear all existing tables, execute below query as well. DROP VIEW IF EXISTS mgw2_inventory_s …
Yash Shah's user avatar
  • 2,513
2 votes
Accepted

Where can I find the cache properties in the Magento 2 database?

Cache statuses are not saved into the database. It is saved inside app/etc/env.php with array key cache_types. There you can find its status 0 or 1. …
Yash Shah's user avatar
  • 2,513
2 votes

Magento 2 delete search term through sql query

The query should be like, DELETE FROM `search_query` WHERE `num_results` = 0; Or you can use following PHP code. protected $queryCollectionFactrory; public function __construct( \Magento\Sear …
Yash Shah's user avatar
  • 2,513
1 vote

Magento 2: How to add sub Query on left join

It seems that you want to join to a table that is retrieving data from another table in your join. In this case, i would suggest to use mysql view concept. So login to your phpmyadmin and create a v …
Yash Shah's user avatar
  • 2,513
2 votes
Accepted

Magento 2 - Syntax error on bin/magento support:backup:db

To take the backup of database, the command i have used is php -dmemory_limit=1G bin/magento setup:backup --db …
Yash Shah's user avatar
  • 2,513
1 vote
Accepted

Error Add Foreign Key Using Install Schema Magento 2

Your entity_id column should look like this. ->addColumn( 'entity_id', \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER, null, ['unsigned' => true, 'nullable' => false, 'index' = …
Yash Shah's user avatar
  • 2,513