I have a SQL Table that doesn't have a primary key but should have which is the account_id, key and index. But unfortunately, I already have millions of entries before I was able to notice this problem. I have account_id…
I have a question and don't know how to approach the problem exactly. I have two tables as following: Clients | c_id | name | reference | | ---- | ------- | --------- | | 1 | ClientA | 1…
I'm seeking for solution on how to get count for 3 faculty code then sum all the count in one variable. I didn't found the right query to combine the count and then sum it. This is the code that…
The following code isn't working: AppModelsNews::groupBy("category")->orderBy('pubDate', 'DESC')->limit(21)->get(); It says id isn't in the group by .... I tried using DB::table and even raw query (DB::raw) but result was the same. I googled and somebody said it's because of the changes…
I'm currently trying to get the last messages in a database in order to make a similar system to other messages system (like Facebook Messenger or WhatsApp) but I want to get the last messages of a "conversation" by the…
I defined specific values in a table with several rows, stored in mysql database on a table named signals for each user using their emails. The user in turn is fills a form which PHP will check against the defined…
I had exported a bunch of tables (>30) as CSV files from MySQL database using phpMyAdmin. These CSV file contains NULL values like: "id","sourceType","name","website","location" "1","non-commercial","John Doe",NULL,"California" I imported many such csv to a PostgreSQL database with TablePlus. However, the NULL…
I have a database about the shop, and I need to return full information of the first 5 customers, which has spent the most amount, and in returned results also display that total amount. (counting all his/her payments together from…
I'm new to php and html and i need some help for my project. I have seen a few examples online but i don't quite understand them. What i want to do is to update the database using a form…
I'm using WordPress with WooCommerce and I have written the following SQL query which gets the product category terms IDs names and slugs: SELECT t.term_id AS id, t.name AS post_title,t.slug AS post_url FROM wp_terms t LEFT JOIN wp_term_taxonomy tt ON…