Linked Questions

I'm have trouble with having to work with ONLY_FULL_GROUP_BY mode (I wouldn't want to, but I'm forced to). The problem is that this requires me to include a column in the group by clause. This is a ...

I have the following table and i want to generate a view. See the result. How can i achieve that? I tried with group_cat but that doesnt work :( id product_id cat_id date 1 1 1 2018-05-...

I'm getting this message everytime I click on the Databases tab up top. Clicking on the error message's Edit link takes me to the SQL Queries section where it shows the SQL query that's listed on the ...

I have the following query: SELECT cn.id, cn.title, cn.type, cn.status FROM ( SELECT v.concert_id as concert_id, SUM(v.position_votes + v.support_votes) as votes FROM ( SELECT q....

When execute my query , I get error message like below. $ads = DB::table('ads') ->join('adimages','adimages.ad_id','=','ads.id') ->select( 'adimages.ad_id', ...

I accidentally enabled ONLY_FULL_GROUP_BY mode like this: SET sql_mode = 'ONLY_FULL_GROUP_BY'; How do I disable it?

$search_alls= DB::table('a16s as A') ->select('A.id') // ->select('A.*') ->addSelect(DB::raw('SUM(CASE WHEN B.approve = 1 ELSE 0 END) as Yshow')) ->leftjoin('a16s_likes ...

i want to get each id's total count from another table named assign job. i saved user data into my users table and i add 3 jobs into assign job table with user id. but now i want to get total added ...

I am building a social network with Laravel framework, and I have a Notifications System. Basically whenever a user interacts with the website in these 5 different ways: User upvotes a Post. User ...

Following is the SQL query that I need to perform on laravel eloquent. SQL returns expected output. SELECT orders.id, orders.`status`, order_type, COUNT(order_type) as count FROM orders ...

I am getting the following error in PHPMyAdmin when I attempt to do click "Databases" tab: #1055 - 'information_schema.s.SCHEMA_NAME' isn't in GROUP BY Please advise on what code in phpmyadmin file ...

I created a helper function for count all notification in navbar, For this I am storing clause in a single variable. I am accessing it by calling- countData("notification","WHERE ...

I have two models: posts and likes. Posts and likes have one-to-many relationship (so, one post has many likes). Likes model has also an isActive field which shows liking is active or passive. I want ...

I have the following problem in a stored procedure: {"code":"ER_WRONG_FIELD_WITH_GROUP","errno":1055,"sqlState":"42000","index":0} Initially I suspected that it was the passing of parameters that ...