Having the following MySQL tables: products: id, name, description categories: id, name, description prodcat: id_product, id_catategory How can I select all the "products" fields and all the "categories" fields of the products that have not been associated to a category?…
Let's take table with name Items and columns: Item,Seller,Price,Date. Now I need to such selector: for any item we need to select minimum Price in some Date interval which was suggested by Seller,if there is more than 1 Date,give only…
I'm trying to load activities from a database with a specific location. I try to do that with this query: public function selectAllActivities(){ $sql = "SELECT * FROM `activities` INNER JOIN `locations` on `activities`.`location_id` = `locations.id`"; $stmt = $this->pdo->prepare($sql); $stmt->execute();…
I have the following query: with current_round as ( select * from match_case_1 where round_id = 12696 ) select * from current_round cr where ( not exists(select * from current_round where gameweek is null) ) or ( exists(select * from…
I have a database where in the accounts table the "username" is the "id". Now I need to add to the table the field "name" which will work as the "id", so if I create a new account, I need…
I'm just playing around with SQL for the first time at the moment and I've been trying to add new columns to an existing table for a student registry sort of deal. I've followed a few tutorials online and they're…
I have two different table in phpmyadmin. One is tbl_user and another is donate. Now I want to take the column donation_date from tbl_user and all columns from the donate table. I want to join one column (donation_date) from tbl_user…
The problem is when I run the code it checks to see if any person has been in department 1 then stops but only want persons that have been in all four departments SELECT p.person_id AS ID, CONCAT(p.firstname, " ",…
I keep having an issue with my SQL query, and I'm not able to resolve it myself after various attempts and research. The error: Warning: #1292 Truncated incorrect DOUBLE value: 'TITLE1_00' Warning: #1292 Truncated incorrect DOUBLE value: 'TITLE2' Warning: #1292…
The webhosting I use has enabled StrictMode for the Databases. All my php scripts now stopped working because they report I haven't defined a default value for some columns. As I have a lot of columns in a lot of…