SELECT DATABASE



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;



EXAMPLE :

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


how to use range in golang

how to use range in golang

posted on 2022-05-03 08:28:11 - Go lang Tutorials


find variable type in golang

find variable type in golang

posted on 2022-05-03 05:24:55 - Go lang Tutorials


for loops in golang

for loops in golang

posted on 2022-05-03 04:27:40 - Go lang Tutorials