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 vote380 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
5 votes381 views3 answers
Show indexes mysql
SQL
0 vote380 views1 answer
Nvl2 syntax
SQL
0 vote377 views1 answer
Pgsql is not permitted to log in
SQL
0 vote370 views1 answer
Date on SQL
SQL
8 votes380 views4 answers
Reset SQL auto increment
SQL
2 votes364 views4 answers
Sql query interview questions
SQL
0 vote443 views1 answer
Mysql show schema
SQL
0 vote395 views1 answer
Sql to search who modified
SQL
2 votes378 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL