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 vote287 views1 answer
Mysql cdn link
SQL
0 vote318 views1 answer
Show tables in cassandra cql
SQL
13 votes489 views4 answers
Sql joining 3 tables
SQL
1 vote306 views1 answer
Vagrant mysql downgrade version
SQL
2 votes290 views1 answer
Mysql find tables with name
SQL
2 votes288 views1 answer
Query to find table size in oracle 12c
SQL
0 vote234 views1 answer
How to get last client id sql
SQL
12 votes278 views3 answers
Duplicate a column in sql
SQL
0 vote293 views3 answers
Insert or ignore postgres
SQL
0 vote312 views1 answer
Is there any limit of using joins in single mysql query ?
SQL