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 am trying to create an offers forum, where some user can create their offers in order to provide their services and I want to show the name of the person that created that offer instead of the id. In…
I have a web app, that logging some events (not important what). My web server is in different timezone , i want to log date and time of my timezone. I created simple DB table with fields: ID - BIGINT…
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…
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, " ",…
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…
I want to export all databases as separate .sql files but I get localhost.sql Can anyone here show me how we can accomplish this?
I installed phpmyadmin on my ubuntu server following these steps here: https://www.rosehosting.com/blog/install-phpmyadmin-on-ubuntu-16-04/ I installed apache, php, mysql following these steps: https://vijayasankarn.wordpress.com/2017/01/17/setting-lamp-stack-in-ubuntu-16-04-using-aws-ec2/ and when I goto login to http://myserver.com/phpmyadmin I get this error: mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using…