...

Database Managment - MySql

Back to Course

Lesson Description


Lession - #1275 SQL Select


What is the syntax of SELECT statement in SQL?

SELECT column1, column2, columnN FROM table_name; Here, column1, column2... are the fields of a table whose values you need to get. To get every one of the fields accessible in the field, then, at that point, you can utilize the following syntax.

Let's see an example



SELECT * FROM EMPLOYEE ;

Output


Try it here
MySQL vs PostgreSQL is a significant choice with regards to picking an open-source social data set administration framework. Both PostgreSQL and MySQL are established arrangements that can rival endeavor arrangements like Oracle and SQL Server.