This is a slightly more complicated reporting problem than I usually have. I want to find how many times customers have repurchased individual product listings. (Say, some products have really high sales, but we want to know how much are…
I’m running a Wordpress-Woocommerce website on a VPS. My VPS configuration is as below: 4 Core CPU 8 GB RAM 40 GB NVMe I’m running CentOS 7 + Cyberpanel + Openlitespeed Server + QUIC CDN + MariaDB. PHP version: 8.1…
I run a laravel app on my website. Since I have expanded my database's one table 'places' to around 12GB in size, the booting time has increased drastically to ~12 seconds for HomePage and ~15 seconds for SearchPage which queries…
I have a trigger on a mysql table that inserts into another table (see trigger below). It would appear this trigger is causing a lock on the other table that is then preventing other inserts into the same table that…
I got two tables in my database.. Users and guestbook UserTable: userID, username, password, email GuestbookTable: gbID, userID, toID, text, date I'm trying to get the userInfo from users with $_GET['userID'] And then im trying to get all the entries…
Struggling to understand how to get the ID of the newly inserted row. This is my procedural mysqli connection and SQL INSERT statement: class DB { var $conn; function __construct($servername, $username, $password, $dbname, $dbport = 0000) { $this->conn = new…
I have a table with 10 columns (stdID, stdName, score1, score2..... Score8). The table has more than 100 student record (stdID) with different scores (score1.... score8). What I want is to make a query that will fetch all the students…
I am using nest.js + typeorm + mySql here are my entities @Entity() export class User { @PrimaryGeneratedColumn('uuid') id: string @Column() name: string @OneToMany(() => Post, post => post.user) posts: Post[] } @Entity() export class Post { @PrimaryGeneratedColumn('uuid') id: string…
I have an expense table where multiple expenses can be tied to an ID, but each of these expenses can have a specific type. I can get the sum of ONE type. SELECT SUM(expense) AS total FROM expenses WHERE id…
I used a little MySQL years ago; now I forgotten a lot and I am lost. Info: MySQL version 5.7.44 - PHP version 8.1.25 What I want to achieve should be simple: I have a DB with 2 tables [Components…