Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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`;
Comment

magento 2 order delete from db

TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;
Comment

PREVIOUS NEXT
Code Example
Sql :: codeigniter print last sql query 
Sql :: postgres get size of database 
Sql :: mysql how to truncate table with foreign keys 
Sql :: fatal error: libpq-fe.h: No such file or directory 
Sql :: alter session set nls_date_format 
Sql :: oracle drop job 
Sql :: find column in all stored procedures sql server 
Sql :: cant install mysqlclient 
Sql :: how to get yesterday date in sql 
Sql :: psql kill pid 
Sql :: fetch first 5 rows in oracle sql developer 
Sql :: oracle table privileges 
Sql :: select duplicates in sql 
Sql :: sql get missing id 
Sql :: sql drop table if exists 
Sql :: tsql copy table 
Sql :: mysql add boolean column 
Sql :: .... ERROR! The server quit without updating PID file mysql centos 
Sql :: ubuntu stop mysql 
Sql :: oracle find text in functions 
Sql :: convert varchar to int in sqlite 
Sql :: mysql last day of next month 
Sql :: check if mysql is installed 
Sql :: postgres DROP and create contraint 
Sql :: add super privilege mysql 
Sql :: postgresql change column to not null 
Sql :: show databases mysql docker 
Sql :: how to delete columns in sql 
Sql :: ifnull postgres 
Sql :: sql find column name like 
ADD CONTENT
Topic
Content
Source link
Name
1+5 =