I have data of the following format: "products": { "handle": "handle1", "tags": "t1, t2, t3, t4, t5" } { "handle": "handle2", "tags": "t1, t6, t7, t5" } : : 100s of products with a unique handle and multiple tags I…
I have to swap short product descriptions with long product descriptions in 200+ products in Woocommerce. Do you know any fast ways to do this? Database query, Better Search&Replace plugin? :-) /swapping it on the front end side (how they…
MySQL (mariadb Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) gave me this error: ERROR 1005 (HY000) at line 129: Can't create table `Houdini`.`stamp` (errno: 150 "Foreign key constraint is incorrectly formed") when trying to create this table:…
I have a working MySQL (MariaDB) Server running on my raspberry pi. It works fine when I want to connect to it from my local network. My specs are as followed: MariaDB [mysql]> SHOW VARIABLES LIKE "%version%"; +-----------------------------------+------------------------------------------+ | Variable_name…
Given a table CREATE TABLE balances ( username varchar(255) NOT NULL, currency varchar(255) NOT NULL, balance numeric NULL, CONSTRAINT balances_pkey PRIMARY KEY (username, currency) ); After attempting CREATE OR REPLACE FUNCTION merge_balance(username varchar(255), currency varchar(255), to_add numeric) RETURNS void AS…
I have a table as follows: CREATE TABLE `table` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `cc` int(3) unsigned NOT NULL, `number` int(10) NOT NULL, `name` varchar(64) NOT NULL, `datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB…
This query lists out the distinct order numbers in Woocommerce that have order either of two products, where the orders are in a status called 'wc-on-hold'. The query does work, but if I comment back in the AND COUNT(t1.ID)=2 it…
I have created a simple SQL statement to display which products customers have purchased from a woo commerce store. This is working great but i'm struggling to find a SQL function that repeats rows based on a value, maybe one…
I'd need to create a sh script, which will connect to Oracle DB and then execute a SQL file. The problem is that sqlplus is not installed on that Cent-OS machine and most probably it won't be installed either. Is…
I have two sites with separate Wordpress instances. One is in the process of getting WooCommerce, the other has existing users with set groups to access courses. I the future access to the courses is supposed to be sold via…