Category: MySql
Attribution data for Woocommerce Orders
Step 1. Get the available keys. Step 2. Get the data for a selected key from the above Step 3. Loop step 2, choosing another key from step 1.
Creating a MySql 8.x Database and user account
Be it for WordPress, or otherwise, creating the database and it’s user account is simple. Just log into MySql as root user, then :
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…