mysql> select * from marks group by marks.student_id; ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlt.marks.subject_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by menna mehema error ekk enne ai? uda thiyana command ek gahuwata passe
very helpfull bro❤❤❤❤ if any one face below error error code : 1055 use this command before execute the query SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
....... Sir Mama M.V.Tharul kisara Gallen ...... Marks Add Kara Ganna phala thiyena code eka hari neda? select * from student_marks group by subject_id; mEka gahuwamath Varadi Kiyala erro ekkak enava 👇👇👇 ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tksoft.student_marks.student_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by HELP ME PLEASE SIR
software field එකේ ඔයාලට තියෙන ඕනම ප්රශ්නයක් ගැන discuss කරන්න අපේ private FB group එකට join වෙන්න..
facebook.com/groups/lankadroid/
Oyalge video mula idan mn bluwa😇😇 full clear explanation ....thank u for helping us😍 digatama me wage video danna ❤❤keep it up💖💖💖💖
කියල දෙන හැම කොටසක්ම ගොඩක් හොදට පැහැදිලිව තේරුම් ගන්න පුලුවන්.ඒ ගොඩාක් හොදට කියල දෙන නිසා.ගන්න උදාහරණය එකම උනත් ඒක හොදයි වෙනින් වෙනින් ඒවා ගන්නවට වඩා.මොකද ඒම ගත්තම කොටස් අපැහැදිලි වෙන්න පුලුවන් නිසා.❤️
ගොඩක් හොඳින් පැහැදිලි කරල දෙනවා.ගොඩක් ස්තුති ..❤️❤️
java code ekkui database ekkui connect karana video tikak karanna puluwannam.. me videos tika nm super idea eka 100% yanawa oluwta.. springboot wage ekak karanna puluwannam hodai aiye💖
Good video series. Recommended
digatma krgena ynn bro...jaya wewa...
Very Helpful!!!! 💖
But could you pleeeeeaaaaaasssseeeee remove the background music in upcoming videos? 🙏
it distracts a little bit.
godak vatinva. Thank you ❤
Ekama example eka aran explain karana eka hodaiii🥰
❤️thank you. Clear explanation
A Very useful lesson ❤
තැන්කිව් බ්රදර්.🔥❤️
Super explain ❤
Thanks bro!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
mysql> select * from marks group by marks.student_id;
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlt.marks.subject_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
menna mehema error ekk enne ai? uda thiyana command ek gahuwata passe
Thank you
Thanks a lot.❤
super lesson thanks
very helpfull bro❤❤❤❤
if any one face below error
error code : 1055
use this command before execute the query
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Padam tika ikmnta dannko aiye plzzzzzz exam ekata godak watinwa....🙏
import karanna .sql files tika danna puluwanda.
Sir mama gallen tharul sirge telegram group ekak thiyanawada??
llink plz😍😍😍
good
❤❤❤
....... Sir Mama M.V.Tharul kisara Gallen ......
Marks Add Kara Ganna phala thiyena code eka hari neda?
select * from student_marks group by subject_id;
mEka gahuwamath Varadi Kiyala erro ekkak enava 👇👇👇
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tksoft.student_marks.student_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
HELP ME PLEASE SIR
ow matath oya error ekama awa. oya ooka problem ek solve kara gttanm kiyanna.
❤❤❤