Search Results
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 |
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 …
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. …
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 …
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 …
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 …
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' = …