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 vote383 views1 answer
Hibernate dialect property xml for mysql 8
SQL
5 votes347 views1 answer
Postgresql functions
SQL
3 votes358 views5 answers
Foreign keys
SQL
0 vote347 views1 answer
Postgres : ERROR: division by zero
SQL
2 votes342 views1 answer
No data found oracle
SQL
0 vote338 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
16 votes361 views6 answers
Install sqlite3 python
SQL
0 vote364 views1 answer
Mysql trigger to delete old data
SQL
3 votes339 views1 answer
Oracle function
SQL
2 votes329 views1 answer
Docker run postgres locally
SQL