List:General Discussion« Previous MessageNext Message »
From:Eldo Skaria Date:October 4 2004 6:57pm
Subject:Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
View as plain text  
Hai Martin,

I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
just the same way for oracle(where i have some (in)experience). so,
"don;'t worry, be happy".

Regards,

Eldo.


On Wed, 29 Sep 2004 11:57:22 +0200, Martijn Tonies <m.tonies@stripped> wrote:
> 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
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 



-- 
Thanks & Regards,
Eldo Skaria
Thread
CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWMartijn Tonies29 Sep
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWEldo Skaria4 Oct
    • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWJochem van Dieten4 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWMartijn Tonies4 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWMartijn Tonies4 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWHarald Fuchs5 Oct
    • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWJochem van Dieten5 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWMartijn Tonies5 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWHarald Fuchs5 Oct
    • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWJochem van Dieten5 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWMartijn Tonies5 Oct
  • Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEWHarald Fuchs5 Oct