Briefly: database imported from foreign source, so I cannot prevent duplicates, I can only prune and clean the database. Foreign db changes daily, so, I want to automate the pruning process. It resides on: MariaDB v10.4.6 managed predominantly by phpMyadmin…
Already checked other answers but unfortunately didn't help me. So im hoping to count how many same id from different table. This is how my tables look like The first table from the left is "resources" and the second is…
Goal: Use php to read, parse, & edit and write data from a view into a pipe delimited outfile. Setup: I have a view “my_view” that has 11 columns/fields. I need data from the first 10 written to the pipe…
My wordpress site has a traffic 3 million users / month, everything was fine until our admin create a post / page. When our admin create post / page, our CPU and RAM usage increase until 100% and the website…
I am following instructions to install MariaDB Galera cluster on Centos 7.6 But, I just cannot get the cluster to start. I can get the MariaDB service started on both nodes. Here is my server.cnf [galera] # Mandatory settings wsrep_cluster_name="galera_cluster"…
Replace in a videos table with a column URL with many different URL types. I use MariaDB 10.3 https://google.com/questions/ask?963 https://google.com/embed/57=66.88.028.10/i/03/077fsdf https://google.com/top57=66.88.028.10/i/03/077 https://video.net/emb.html?asdeen45dr57=66.88.028.10/i/03/07776/asdeen45dr57 https://video.net/fomdfk5f7s1f.html https://video.net/emb.html?qsfeen4gttv1=54.47.158.810/i/11/00036/qsfeen4gttv1 I need to delete part of a specific URL (delete all after =) and replace with…
I'm doing a PDO UPDATE query to MariaDB database. $query = "UPDATE :table SET `name`=:name, `title`=:title, `description`=:description WHERE id=:id"; $stmt = $this->conn->prepare($query); $stmt->bindParam(':table',$this->table, PDO::PARAM_STR); $stmt->bindParam(':id',$this->id, PDO::PARAM_INT); $stmt->bindParam(':name',$this->name, PDO::PARAM_STR); $stmt->bindParam(':title',$this->title, PDO::PARAM_STR); $stmt->bindParam(':description',$this->description, PDO::PARAM_STR); $stmt->execute(); It seems to me that everything is…
I can't understand why sql gave me an error #1064. I just followed the instruction at this Full Outer Join - Save Output in new table I tried putting "INSERT" syntax before the "INTO" but the error is the same…
I would like to install MariaDB version 5.5.56 on CENTOS 7(EC2 Instance). I tried using the command sudo yum install MariaDB-server-5.5.56 But it says the package is unavailable. I need this specific version of MariaDB and I cant seem to…
I need to write a query which must include use of INNER JOIN, but did not manage to write it correctly. In PhpMyAdmin, I created a database with two related tables of users: Table #1 is called "Usertype" and has…