Select all columns with one alias column in MySQL:
select FirstName as FN, * From `User`
If you try to run the above query you will get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
The solution is to add an alias to * in the above query:
select FirstName as FN, User.* From `User`
In the above query, we added the table name as an alias to * to fix the issue.