Day 1: Database āĻāĻŦāĻ Table āϤā§āϰāĻŋ āĻāϰā§āĻāĻŋ
Day 2: Data insert āĻāϰā§āĻāĻŋ āĻāĻŦāĻ rules āĻļāĻŋāĻā§āĻāĻŋ
Day 3: āĻāĻŦāĻžāϰ āϏā§āĻ data āĻā§āϞ⧠āĻĻā§āĻāĻŦ āĻāĻŦāĻ āĻā§āĻāĻāĻŦ!
SELECT āĻšāϞ⧠SQL āĻāϰ āϏāĻŦāĻā§āϝāĻŧā§ āĻŦā§āĻļāĻŋ āĻŦā§āϝāĻŦāĻšā§āϤ commandāĨ¤ āĻāĻāĻž āĻĻāĻŋāϝāĻŧā§ āĻāĻŽāϰāĻž database āĻĨā§āĻā§ data āĻŦā§āϰ āĻāϰāĻŋāĨ¤
SELECT * FROM students;
āĻŦā§āϝāĻžāĻā§āϝāĻž:
SELECT * = āϏāĻŦ column āĻĻā§āĻāĻžāĻFROM students = students table āĻĨā§āĻā§Output:
| Name | StudentID | Age | Joindate | |
|---|---|---|---|---|
| Osru | 1 | 21 | osru@example.com | 2026-02-11 |
| Rahim | 2 | 22 | rahim@mail.com | 2024-01-15 |
| Karim | 3 | 20 | karim@mail.com | 2024-01-16 |