How to SELECT to remove all columns of a certain column in MySQL?

Question

Because there are dozens of columns in the table, is there any simple way to SELECT to remove all columns of a certain column?

Similar to the following syntax:

SELECT * [except columnA] FROM tableA

Answer 1

I don’t know which database has this syntax.

The key is not to know the actual meaning of this. If there are many fields, use select * to process them. If there are few fields, write the field list yourself.
If you really want to write it like this, you can only dynamically splice the sql statement with strings based on the metadata of the table.