tag:blogger.com,1999:blog-17155656.post114212892947119086..comments2023-04-06T12:09:13.895+02:00Comments on db4free.net blog: Still no access to the original view definitionMarkus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-17155656.post-89049588815952405492011-01-15T00:32:22.850+01:002011-01-15T00:32:22.850+01:00USE information_schema;
SELECT view_definition FRO...USE information_schema;<br />SELECT view_definition FROM VIEWS where TABLE_NAME = v_checktest;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-17155656.post-43366573730845365962008-02-21T20:52:00.000+01:002008-02-21T20:52:00.000+01:00thank U dear friendthank U dear friendpkp thikkotihttps://www.blogger.com/profile/02795921542540135171noreply@blogger.comtag:blogger.com,1999:blog-17155656.post-1142145508591112022006-03-12T07:38:00.000+01:002006-03-12T07:38:00.000+01:00For information, the mysql command-line client str...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.<BR/><BR/>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.Anonymousnoreply@blogger.com