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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- Thanks & Regards, Eldo Skaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
