Mysql query multiple tables and inner join
I have 3 tables and I want to have a query that gives me the sum of the sales, the sum of the deposits and the difference between them, try this but the records are duplicated. this is my query:…
Laravel – query eloquent in controller null result, why?
$rooms3 = Room::join("notifications", "notifications.room_id", "rooms.id") ->where('rooms.user_id', Auth::user()->id) ->join("watt_histories", "watt_histories.notification_id", "notifications.id") ->where('notifications.id', 'watt_histories.notification_id') ->latest('watt_histories.created_at') ->first(); If the query runs well, the return given is not null
UNION ALL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
I am using Union All for two select query. Both side the query is different I have to find the records from both table and show. I have tried below query but I am getting error #1064 - You have…
phpMyAdmin questions?
In phpMyAdmin > status you can monitor this charts (see image below), what is questions? And what rate is it, per second, per minute or? If its per second its very high for even a simple php script with three…
Mysql – Selecting column from a table with different orders
I have a table customer. The table has columns cust_id, member, date. The cust_id is a primary key (auto-increment), member can have either 1 or 0 and date contains the timestamp. I want to run a query on MySQL which…
Mysql – How do you query a main table with known duplicates that also have tags?
I have a main table called pics that has an ID number and the origin site from which it was pulled from. I also have another table called tags that has a list of all the tags that were also…
Mysql count if the value less or greater than other value
SELECT wilayah,nilai,t_rkpd,tahun,periode FROM nilai_indikator INNER JOIN provinsi ON nilai_indikator.wilayah=provinsi.id WHERE tahun='2022' AND periode='08' AND id_indikator='6' When i query that code the result is like this table I try count if the nilai is less or greater than t_rkpd, using this…
Phpmyadmin – Can a database table work differently for each user?
Im working on an employee management system using java and javafx. im just wondering ;in this project there's an admin part and there's an employee part. Employees will sign up and login then after logging in they enter their personal…
Phpmyadmin – WordPress error: 'The uploaded file could not be moved to wp-content/uploads'
I've tried updating permissions to every possible combination for both the wp-content folder and also the uploads folder within it and it hasn't remedied the issue. I also saw in a few threads of similar issues that adding define('FTP_PUBKEY','/home/wp-user/wp_rsa.pub'); define('FTP_PRIKEY','/home/wp-user/wp_rsa');…
Phpmyadmin – "Source file could not be read" error when exporting database
I made a draft of a Wordpress website on localhost using XAMPP. I made a database for it using MySQL. I'm ready to upload to BlueHost. I understand that means I need to save the database as a single .sql…