what is de real sintaxis from SELECT

Question

SELECT OR SELECT* (i dont understand)

Answer 1

SELECT [fields] FROM [table]

Fields are coma separated or asterisk for all

// Get just name & Age
SELECT name,age FROM person;

// Get all columns
SELECT * FROM person;

Answer 2

Say suppose 3 columns are there in a database table such as NAME , ID , MOBILE NUMBER.

if you want to select name from the table
You write query as
Select NAME from Table_name

If you want to display all the columns
Then instead of mentioning all the column names,we can say simply,

Select * from table_name

Answer 3

The SELECT statement is used to select data from a database
SELECT column1, column2, ...
FROM table_name;

If you want to select all the fields available in the table, use the following syntax:
SELECT * FROM table_name;