MySQL - Select Database
This statement is used to select data from a database and the data returned is stored in a result table, called the result-set.
Syntax :
SELECT column1, column2, ...
FROM table_name;
--(*) is used to select all from the table
SELECT * FROM table_name;
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 - Grant_ Revoke Privilege
posted on 2019-11-26 23:15:04 - mysql Tutorials