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