0

is it possible to set a column alias with use of SELECT * FROM table_name?

e.g.:

  • this query return every columns
SELECT id as table_name_id, name as table_name_id, description as table_name_id FROM table_name
  • obviously can be written in a more convenient way like:
SELECT * FROM table_name

But there is some way to set the same table prefix to all columns results? something like SELECT * as prifix_ FROM table_name ?

Thank you!

red
  • 1,529
  • 1
  • 12
  • 33

0 Answers0