What is the use of * in mysql

Answer 1

Check this out:
https://www.sololearn.com/learn/SQL/1852/

Answer 2

The * is used to select all fields in a table without having to list each individual field.

For example, say you have a table named customer that contains 3 fields: id_num, name, address.

If you need to pull all of the fields you can write:
SELECT id_num, name, address
FROM customer

or you could write:
SELECT *
FROM customer