R Racer_X Eternal Poster Joined May 2, 2020 Posts 693 Reaction 178 Points 358 Nov 19, 2021 #1 guys tanong ko lnag po kung ano po query pede gamitin . .. if gusto ko po makita yung laman ng isang field from a table .. sana po matulungan nyu po ako . . salamat po ng marami . baguhan lang po . .nag search po ako kasu waala ako makita ..
guys tanong ko lnag po kung ano po query pede gamitin . .. if gusto ko po makita yung laman ng isang field from a table .. sana po matulungan nyu po ako . . salamat po ng marami . baguhan lang po . .nag search po ako kasu waala ako makita ..
M masterA2Z Addict Nov 19, 2021 #2 Use the ff command: select <column> from <table> <where condition = value> . Yung <where condition = value> ay optional, just for filtering. e.g. a. list all grades in the student table select grade from studentTbl; b. list grade of student with name that is 'abc' in the student table select grade from studentTbl where name = 'abc'; c. list all columns and their value in the student table select * from studentTbl; HTH
Use the ff command: select <column> from <table> <where condition = value> . Yung <where condition = value> ay optional, just for filtering. e.g. a. list all grades in the student table select grade from studentTbl; b. list grade of student with name that is 'abc' in the student table select grade from studentTbl where name = 'abc'; c. list all columns and their value in the student table select * from studentTbl; HTH
R Racer_X Eternal Poster Nov 20, 2021 TS TS #3 masterA2Z said: Use the ff command: select <column> from <table> <where condition = value> . Yung <where condition = value> ay optional, just for filtering. e.g. a. list all grades in the student table select grade from studentTbl; b. list grade of student with name that is 'abc' in the student table select grade from studentTbl where name = 'abc'; c. list all columns and their value in the student table select * from studentTbl; HTH Click to expand... salamat po ng marami . gets ko na po
masterA2Z said: Use the ff command: select <column> from <table> <where condition = value> . Yung <where condition = value> ay optional, just for filtering. e.g. a. list all grades in the student table select grade from studentTbl; b. list grade of student with name that is 'abc' in the student table select grade from studentTbl where name = 'abc'; c. list all columns and their value in the student table select * from studentTbl; HTH Click to expand... salamat po ng marami . gets ko na po