Here my MySQL query (work in phpMyAdmin) : SELECT workcenter, (SUM(w1+w2 +w3 +w4)/ (COUNT(DISTINCT(teknisi))*40*4) )*100 AS total FROM `team` GROUP by workcenter ORDER BY total then, i try in Laravel Sintax like this below (not work) : $sql = Team::groupBy('workcenter')->select('workcenter',…
I have the following SQL: SELECT members.id, FLOOR(DATEDIFF('2019-10-25', crew_cv.dob) / 365.25) as age FROM members JOIN crew_cv ON members.id=crew_cv.user_id WHERE members.active=1 AND age>20 AND age<30 ORDER BY crew_cv.last_name, crew_cv.first_name LIMIT 0,30 And I get the following error in phpMySQL: #1054…
So I have database with amount and created_at field on it and I want to the total amount per month of the current year and or every year. $sql = 'SELECT SUM(amount) as "Amount",MONTHNAME(created_at) as "Month" FROM transactions WHERE YEAR(created_at)…
This is my first time creating a sql procedure, and i need some help. What i am trying to do is to create a procedure that returns true or false if the user has correctly inputed his email and password…
How can I calculate the average of a person (in this case player) x & y position whilst creating a new table and adding said average to a new column. CREATE TABLE PlayerStatistics AS SELECT PLAY_Name FROM player; ALTER TABLE…
I need to modify MySQL code to pass this error and get the same result. I use localhost with Xampp .. Apache/2.4.29 (Win32) OpenSSL/1.1.0g PHP/7.2.1 Server type: MariaDB Server version: 10.1.30-MariaDB - mariadb.org binary distribution Database client version: libmysql -…
I am trying to query a few tables however to simplify it ill make it specific to one table. have a look at the table view i have the attribute_id column and each row has an attribute id and some…
I am trying to search a table where I have daily ranked keywords (SEO keywords). Therefore I have index on a key_id per keyword, and new position value per each keyword. I would like to find out how I can…
I have a table named Seller and another table api_tokens. I want to remove all rows from api_token table of the seller when specific column email/password is updated from Seller. sellerId is the foreign_key in tokens table. userID is the…
I want to update a table with a new url to replace the old one: UPDATE table1 SET column1 = REPLACE(column1, 'OLD URL', 'NEWURL') WHERE column LIKE '%OLDURL%' This updates it mostly but I only want to replace part of…