What does * mean in sql?

Question

For example, I know what SELECT * FROM example_table; means. However, I feel uncomfortable not knowing what each part of the code means.

Answer 1

The second part of a SQL query is the name of the column you want to retrieve for each record you are getting.

You can obviously retrieve multiple columns for each record, and (only if you want to retrieve all the columns) you can replace the list of them with *, which means "all columns".

So, in a SELECT statement, writing * is the same of listing all the columns the entity has.

Here you can find probably the best tutorial for SQL learning.

Answer 2

I am providing you answer by seperating each part of code.

SELECT == It orders the computer to include or select each content from the database name(table ) .

(*) == means all {till here code means include all from the database.}

FROM == It refers from where we have to select the data.

example_table == This is the name of the database from where we have to select data.

the overall meaning is :

include all data from the databse whose name is example_table.

thanks.