Category: MySql
Dovecot Sieve : Run Bash shell Scripts to query Mysql
3 simple scripts to determine Out Of Office emails for Dovecot First, the Sieve file Then the two Bash Scripts
SQL to extract order report
This SQL string will extract multiple meta values from an order.
Exporting/Importing Woocommerce Orders with SQL 2020
Covers WordPress version 5.3.2 No matter how you use the SQL, be it on the command line, PhpMyAdmin or PHP, These are just the SQL commands needed. There are 4 tables invlovled not counting the variable product data. I’ll be adding that as soon as a get a free moment. wp_posts wp_postmeta wp_woocommerce_order_items wp_woocommerce_order_itemmeta wp_posts…