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


Prompt Examples

ChatGPT Prompt Examples

posted on 2023-06-21 22:37:19 - ChatGPT Tutorials


Use Cases

Chat GPT Key Use Cases

posted on 2023-06-21 21:03:17 - ChatGPT Tutorials


Prompt Frameworks

Prompt Frameworks

posted on 2023-06-21 19:33:06 - ChatGPT Tutorials