Sunday, March 12, 2006

Still no access to the original view definition

This blog post has moved. Please find it at:

http://www.mpopp.net/2006/03/still-no-access-to-the-original-view-definition/.

3 comments:

Anonymous said...

For information, the mysql command-line client strips comments before sending them to the server so if views are created that way they won't be available to it. This is also somewhat inconvenient when you rely on comments to control tools based on SHOW PROCESSLIST and such.

If you want the mysql client to not strip comments (and do specify /* */ or -- types or both) that would be a feature request for it as well. If you do decide to file such a request, please let james atsign mysql.com know.

Pratheesh said...

thank U dear friend

Anthony said...

USE information_schema;
SELECT view_definition FROM VIEWS where TABLE_NAME = v_checktest;