Where Clause | MySQL Sinhala Tutorial | Part 08

[@lankadroidProgrammmingKuppiya]

software field එකේ ඔයාලට තියෙන ඕනම ප්‍රශ්නයක් ගැන discuss කරන්න අපේ private FB group එකට join වෙන්න..
facebook.com/groups/lankadroid/

[@hasijayaweera8064]

Kiyala dena විදියට හොඳටම therenawa... oyata ගොඩාක් pin...🙏💐

[@lankadroidProgrammmingKuppiya]

අන්තිම example එකේ query එක වෙනස් විදියකට ලියන්නත් පුළුවන්.. හිතලා බලලා try කරපු අය query එක comment කරමු.. :)

[@shammiariyarathna3921]

SELECT * from Student_marks WHERE subject_id ='SUB001' OR subject_id='SUB002' AND marks>50;

[@sewminikangara007]

SELECT*FROM students_marks WHERE subject_id ='SUB001' OR subject_id='SUB002' AND marks>50 ;

[@m.v.tharulkisara528]

SELECT * from Student_marks WHERE subject_id ='SUB001' OR subject_id='SUB002' AND marks>50;

[@kushanweerarathne2679]

select * from Student_marks where (subject_id='SUB001' or subject_id='SUB002') and marks>50;

[@CeylonCapture]

ගොඩාක්ම වටිනවා. පුළුවන් නම් joins ටිකත් ඉක්මනින් upload කරන්න. Nvq exam thiyenva මේ මාසේ 19.

[@madhushipraveena]

SQL ගොඩදාගන්න මේ video series එක ගොඩක් වටිනවා. Next episodes ටිකත් ඉක්මනින් upload කරන්න.
Thank you!

[@HasiPrasa-ke2hy]

Foreign key eken table ekata data insert kre kohomada?

[@jisankaganegoda6138]

Me video tika godak watinawa ayye.harima pahadili kiyala dena widiya.Thank you me videos tika share kalaata!

[@TempoDisc]

Godak interesting widihata ayya kiyala denawa... Godak pin...

[@24HK340]

Hodatama teruna 😍💓 thanks a lot

[@dailydose_-_]

superb learning channel ever.thank you so much 🎉

[@shammiariyarathna3921]

This is so valuable & can understand easily.It is vry interesting when you teach these things.Thank you soo much.Keep it up.All d very best.

[@yukeenanayakkara-5540]

very helpful. very good teacher

[@himanshanawarathna5931]

Thank you so much !

[@m.v.tharulkisara528]

😍😍😍Good Video😍😍😍

[@warunikasenaratne1470]

❤️🔥 godak sthuthii!

[@KshithijaniDissanayaka]

niyamai ❤

[@isurusandaruwan1529]

ගොඩක් ස්තූතියි

[@harshanikaushalya8934]

ගොඩක් ස්තූතියි 🙏❤

[@kazwicable]

Great information thank you

[@dinushachathuranga7657]

Thanks for the video💖

[@j-us-t-me]

Thank you sooo much bro

[@animaxdon-om6bn]

supiri🤗🤗🤗🤗

[@madusankabibile8257]

Thanks

[@asvinmedical1329]

student_marks ekata data enter karana widiha kiyanawada? error ekak enawa.

[@animalslife5703]

Thank you

[@HasiPrasa-ke2hy]

Mata eka prashnayak awa student_marks table eka fill karaddi error awa. Foreign key eka Nisa. Eka kohomada fill wenne? Auto gaththeth nane. Explain karanna puluwanda?

[@cyb.x]

🔥🔥❤❤

[@dini3776]

❤❤❤❤❤

[@SasikaAlawatta]

{"status":false,"message":"Errore nel database: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`stage`.`contract`, CONSTRAINT `contract_ibfk_2` FOREIGN KEY (`id_admin`) REFERENCES `admin` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)","data":null} mekata mokada karanna ona

[@lankadroidProgrammmingKuppiya]

Foreign key ekakata data insert karaddi eka refer karana parent table eke column eket value eka tiyenna ona.. eka double check karanna..

[@RSMusic_Official]

🥰

[@bishmidissanayaka799]

Api foriegn table walatat records wenama enter krn inns oneda?

[@sewminikangara007]

♥️♥️♥️♥️

[@m.v.tharulkisara528]

....... Sir Mama M.V.Tharul kisara Gallen ......
Marks Add Kara Ganna phala thiyena code eka hari neda?
insert into student_marks(student_id, subject_id,marks)
values(001,'SUB001',50);
muka gahuwamath Varadi Kiyala erro ekkak enava 👇👇👇
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`tksoft`.`student_marks`, CONSTRAINT `student_marks_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `student` (`student_id`))
Help Karannako mnata plz

[@lankadroidProgrammmingKuppiya]

SUB001 refer karanne subject table ekenne.. mulinma eke values tika dala inna.. me error eke kiyamme sunject table eke subject id eka na kiyala..

[@m.v.tharulkisara528]

@@lankadroidProgrammmingKuppiya ok sir

[@DevindaDilshan-m2j]

[@m.v.tharulkisara528]

Sir Table Ekata Enter Karapu Data Ekak Drop karanna kramayak thida????

[@lankadroidProgrammmingKuppiya]

th-cam.com/video/Luh9cmUXK9c/w-d-xo.html
Puluwan. Me video eke tiyenne eka.. okkoma video tika mula indan piliwelata balan yanna.. ona wena piliwelata tamai ape video tika dala tiyenne..

[@m.v.tharulkisara528]

@@lankadroidProgrammmingKuppiya ok sir thankyou

[@nilupultharanga9836]

❤️

[@HoTial1]

පට්ට ❤️❤️❤️ හැබැයු mark ටේබල් එක ෆිල් කරන වීඩියෝ එක නෑ නේ 😐😐

[@lankadroidProgrammmingKuppiya]

Inser video eke ati table walata data fill karana tika..

[@poornimasandarenu]

Thank You