SELECT QUERY



MySQL - Select Query


The SQL SELECT command is used to fetch data from the MySQL database.


SYNTAX  

SELECT column1, column2, ...
FROM table_name;

--(*) is used to select all from the table

SELECT * FROM table_name;



As a result following table gets displayed :


Select StudentName from studentinfo;

-----RESULT------

-----------------
|  StudentName   |
-----------------
|Manjusha       |
|Noothan        | 
|Meherish       |
|Ajaashi        |
|Sahayana       |
|Sweekrutha     |
|Manju          |
|---------------|

Select * from Studentinfo;


--------RESULT---------

------------------------------------------
| StudentID | StudentName | StudentClass |
------------------------------------------
| 1         |Manjusha     |fifth         |
| 2         |Noothan      |sixth         |
| 3         |Meherish     |seventh       |
| 4         |Ajaashi      |eighth        |
| 5         |Sahayana     |ninth         |
| 6         |Sweekrutha   |tenth         |
| 7         |Manju        |tenth         |
------------------------------------------



MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials


What Is Oracle

What Is Oracle

posted on 2019-11-29 01:11:21 - ORACLE Tutorials


TRIGGER

ORACLE - Trigger

posted on 2019-11-28 22:14:22 - ORACLE Tutorials


CURSOR

ORACLE - Cursor

posted on 2019-11-28 22:13:54 - ORACLE Tutorials