and i want do disable the quotes for fieldnames and tablenames.
when i save a view like this
Code: Select all
CREATE
DEFINER = 'root'@'localhost'
VIEW x
AS
SELECT
testtable.LCHANGE
FROM testtable;
Code: Select all
CREATE
DEFINER = 'root'@'localhost'
VIEW x
AS
SELECT
`testtable`.`LCHANGE` AS `LCHANGE`
FROM `testtable`;
but i doesnt have an effect.
And is it also possible to disable the alias?