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
just the same way for oracle(where i have some (in)experience). so,
"don;'t worry, be happy".
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
> Upscene Productions
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Thanks & Regards,