From: Martijn Tonies
Date: September 29 2004 9:57am
Subject: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
List-Archive: http://lists.mysql.com/mysql/173392
Message-Id: <023301c4a60a$b74dceb0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi there,

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?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com