Closed Database design tutorial - part 5 - creating db and tables

[codyscott]

Part 5.

Creating database and tables using MYSQL - PHPMYADMIN

Download PDF

 

[Heks]

master for C# meron ka po ?

 

[codyscott]

master for C# meron ka po ?

like C# programming tutorial?
sa ngayon wala pa.

 

[Heks]

Retrieve the subject id from tblStudents_subjects recorded twice or more and display them with number of records. (baka po matulungan nyo ko ) salamat po

 

[Heks]

eto po ung table nya

 

[codyscott]

Retrieve the subject id from tblStudents_subjects recorded twice or more and display them with number of records. (baka po matulungan nyo ko ) salamat po

just quick and on top of my head, ganito:

solution 1: programmatically
- query and select mo lahat (that will give an array)
- get that array perform "compare". C# has some kind of comparator
- then count duplicates

solution 2: sql query
- hints: "HAVING COUNT > 1"

See if you can get it.
Gagawa ako ng test ko just to make sure.

 

[codyscott]

View attachment 455104
eto po ung table nya

try this:

SELECT studid, COUNT(*) count_result FROM tblstudents_subjects GROUP BY studid HAVING count_result > 1

 

[Heks]

try this:

SELECT studid, COUNT(*) count_result FROM tblstudents_subjects GROUP BY studid HAVING count_result > 1

Salamat po master try ko yan

 

[codyscott]

Think of them as different "companies" (MySQL and Oracle).
- they both provide database architecture or what not
- pero MySQL is an Open-Source (free)...Oracle is "ρáíd"
- they both use SQL as their "language" para hugutin ang data from the database (very small syntax difference)

 

[Heks]

try this:

SELECT studid, COUNT(*) count_result FROM tblstudents_subjects GROUP BY studid HAVING count_result > 1

master hhehehe salamat po okay na po sya ) pwede pa po patulong ? if pwede pa

 

[electromagnus06]

salamat po lodi

 

[rizap123]

need po ba mag dl ng xampp para sa mysql boss??

 

[codyscott]

need po ba mag dl ng xampp para sa mysql boss??

hindi mo naman kailangan ang xampp kung kaya mong i-install isa isa ang mga components (Apache, PHP, MYSQL).
- otherwise, kailangan mo ng some kind of package (XAMPP or WAMPP) para isang installation na lang lahat at wala ka ng po-problemahin

 

[codyscott]

BTW, re-download nyo uli yung PDF kasi hindi ko napansin na malabo pala yung images. I tried to make it more readable dito sa bagong PDF.

 

[Heks]

guys please help me ulit.. d ko talaga makuha to e

Retrieve from the tblStudents the student id and first name in the records whose year of birth is from 1980 to 1985.

eto po ung table salamat po huhu

 

[Heks]

guys please help me ulit.. d ko talaga makuha to e

Retrieve from the tblStudents the student id and first name in the records whose year of birth is from 1980 to 1985.

eto po ung table salamat po huhu
View attachment 455875

d ko talaga malimitahan ung dapat na 1980 to 1985 lng

 

[codyscott]

guys please help me ulit.. d ko talaga makuha to e

Retrieve from the tblStudents the student id and first name in the records whose year of birth is from 1980 to 1985.

eto po ung table salamat po huhu
View attachment 455875

SELECT * FROM `tblstudents`
WHERE (bday BETWEEN '1980-01-01' AND '1985-12-31')

 

[Shamballaa]

paps baket pag nirurun ko lumalabas object not found ?

 

[Thebeast_06]

salamat po