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

4 votes312 views2 answers
Oracle unliock account
SQL
0 vote366 views1 answer
Change date format in oracle query
SQL
12 votes333 views1 answer
Docker mysql random root password
SQL
0 vote272 views1 answer
Copy table dbeaver
SQL
0 vote330 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote340 views1 answer
Sql period overlap
SQL
2 votes324 views1 answer
No data found oracle
SQL
1 vote329 views1 answer
Ubuntu access database from terminal
SQL
0 vote357 views1 answer
Oracle current date minus 1 day
SQL
2 votes349 views1 answer
Revokeprivileges mysql
SQL