I'm testing MySQL 5.0.1 a bit - and I noticed the following...
When executing this:
create view myview2 (t0)
as select c1 from t
It returns this when doing a SHOW CREATE VIEW myview2:
CREATE VIEW test.myview2 AS select `test`.`t`.`c1` AS `t0` from `test`.`t`
This is not at all what I entered.
I dislike backticks unless I specify them. I don't want a database
name included unless I specify it (from `test`.`t`).
Can the annoying behaviour be changed or turned off?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL