Script for database (Select one table in database)
Example of database table :
The table name is University
Example
SELECT * FROM University
The display is :
Example
SELECT Names FROM University
The display is :
WHERE Condition
Example
SELECT * FROM University
WHERE Names = 'Aries'
The display is :
The table name is University
| Code | Names | Value |
| A01 | Leo | 90 |
| A02 | Aries | 100 |
| A03 | Taurus | 95 |
- Select all rows all fields
Example
SELECT * FROM University
The display is :
| A01 | Leo | 90 |
| A02 | Aries | 100 |
| A03 | Taurus | 95 |
- Select all rows one fields
Example
SELECT Names FROM University
The display is :
| Leo |
| Aries |
| Taurus |
- Select any rows all fields or one row all fields (use where)
WHERE Condition
Example
SELECT * FROM University
WHERE Names = 'Aries'
The display is :
| A02 | Aries | 100 |
No comments