How do i modify the result of this SQL query?
Issue Here is the curren query select usr.COUNTRY, round(ifnull(sum(CASE when de.comment like ‘%BT%’ THEN de.PROFIT END),0),2) AS OCPAY, round(ifnull(sum(CASE when…
Category: MySQL
Group by number of occurrences based on the result of a group by query
Issue Imagine a table posts like this posts — id user_id title If I want to print out each user…
Why expression in the MySQL HASH partitioning must be greater than 0 (zero)?
Issue In the MySQL document, it is written as follows. For HASH partitioning, the user-supplied expression must evaluate to an…
Group by weeks in a range of date
Issue I am using a MySQL database and I’m trying to group the result by weeks, I know how to…
Do MySQL databases implement Transactions by Default?
Issue I was wondering what happens when several users try to UPDATE a MySQL database at the same time. Went…
Can you split/explode a field in a MySQL query?
Issue I have to create a report on some student completions. The students each belong to one client. Here are…
Stored procedure and select query return different result in MySQL
Issue I am using MySQL and MySQL workbench. This is my stored procedure: CREATE DEFINER=`root`@`%` PROCEDURE `sms_stats`( IN fromDate VARCHAR(8),…
how to use count() in controller?
Issue How do I get the number of rows here? When I use $count = $flights->count(); I get this error…
why the date information cannot be saved into mySQL database?
Issue My code is in PHP Laravel. And I tried to create a table in font-end which allow user to…
SQL request, find people closest to me with MySQL
Issue I am currently working on a WordPress/PHP/MySQL project. I would like to run a query to find people geographically…