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 vote110 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote97 views1 answer
Doesn't have default value mysql
SQL
0 vote104 views1 answer
Sql get year from datetime field
SQL
24 votes98 views6 answers
Sql change table name
SQL
0 vote106 views1 answer
Mssql check if date is greater than today
SQL
2 votes105 views1 answer
SQL column name Postgre
SQL
0 vote107 views1 answer
How to reset the database value in SQL server
SQL
-1 vote91 views1 answer
How to format tables in sqlplus
SQL
2 votes98 views1 answer
Dbms transaction (psql)
SQL
0 vote92 views1 answer
How to reset AI in sql
SQL