From: Martijn Tonies
Date: October 4 2004 7:06pm
Subject: Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW
List-Archive: http://lists.mysql.com/mysql/173590
Message-Id: <04c301c4aa45$45485490$c802a8c0@martijnlaptop>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Eldo,

> 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".

This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.

MS SQL, or Firebird, for example, store the view-source as defined -
this includes comments, spacing etc etc... In short: it becomes usuable.

MySQL should do this too. From reading these lists, I think MySQL
only stores the resulting structure - or something similar - and
(currently) not the view source. To make views useful, better change
it... :-)

With regards,

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