3. SELECT Basics: Read Rows Without Changing Data
3.1 What SELECT Does (Read Only — Safe to Practise)
Why. Fear of breaking data stops beginners. SELECT is read-only.
What. SELECT reads rows. It does not UPDATE or DELETE unless you write those words.
How. Start every practice day with SELECT … FROM … LIMIT.
Steps
- Open raja_coffee.
- Run a small SELECT with LIMIT.
- Confirm Browse Data still looks the same.
Examples
Example 1 · dataset: raja_coffee
SELECT order_id, amount_inr FROM orders LIMIT 3;Output
| order_id | amount_inr |
|---|---|
| 1001 | 840.0 |
| 1002 | 720.0 |
| 1003 | 890.0 |
Meaning. Three amounts — data unchanged after the query.
Ravindra Bagale's Tip
If the statement starts with SELECT, you are in safe practice mode.
Ravindra Bagale's Tip – मराठी
Statement SELECT ने सुरू होत असेल तर तुम्ही सुरक्षित सराव मोडमध्ये आहात.
Ravindra Bagale's Tip – हिंदी
अगर statement SELECT से शुरू हो तो आप सुरक्षित अभ्यास मोड में हैं।