Magento 2 order delete from db

SET FOREIGN_KEY_CHECKS=0;

Source: stackoverflow.com

Magento 2 order delete from db

TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

Source: magento.stackexchange.com

Magento 2 order delete from db

TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;

Source: magento.stackexchange.com

Similar codes

0 vote215 views1 answer
Command line mysql xampp
SQL
1 vote194 views1 answer
Psql import backup file for windows
SQL
0 vote178 views2 answers
Sqlite unix timestamp
SQL
0 vote186 views1 answer
Mysql calculated column
SQL
2 votes186 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote166 views1 answer
Sql random decimal
SQL
0 vote192 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
9 votes166 views3 answers
Mysql get last id
SQL
0 vote182 views1 answer
ORACLE PARSE STRING
SQL
0 vote171 views1 answer
How to convert DateTime to VarChar SQL
SQL