Create View Auto Format

[Daniel Otremba]

Hello,

When i create a view lIke:

create view mysql.test as
select
db_name,
table_name
from mysql.column_stats

it will always auto Formated like This:

select
`mysql`.`column_stats`.`db_name` AS `db_name`,
`mysql`.`column_stats`.`table_name` AS `table_name`
from
`mysql`.`column_stats`


Is it possible to turn this off?
I mean the Table name bevor the columns and this stupid sign "`"
Why mysql do this?

plz Help me.

Im shortly before freaking out