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

2 votes204 views1 answer
Oracle trace file
SQL
0 vote210 views1 answer
Show tables in cassandra cql
SQL
17 votes242 views6 answers
Sql current date
SQL
2 votes181 views2 answers
Mysql get time from datetime
SQL
1 vote211 views1 answer
Round one decimal place mysql
SQL
0 vote175 views1 answer
Char vs varchar2 in sql
SQL
0 vote182 views1 answer
Mysql locate
SQL
3 votes176 views1 answer
Oracle wait
SQL
0 vote173 views1 answer
C# mysql update statement set value to null
SQL
3 votes188 views1 answer
Sql double index
SQL