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

13 votes124 views4 answers
Command line mysql import
SQL
1 vote117 views2 answers
Remove space in mysql
SQL
1 vote114 views1 answer
Show per page table in xampp
SQL
1 vote116 views2 answers
Replace text in sql
SQL
0 vote119 views1 answer
Null column as zero in mysql
SQL
0 vote109 views1 answer
Go install mysql
SQL
0 vote113 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote121 views3 answers
Nth highest salary
SQL
3 votes116 views2 answers
Sqlite print all column names
SQL
0 vote113 views1 answer
Postgres where
SQL