This is all about db4free.net and the database systems that it offers. The main focus are practical examples of the new features of MySQL 5 and 6 that should show you how to use them for your advantage in your daily life ;-).
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.
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.
ReplyDeleteIf 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.
thank U dear friend
ReplyDeleteUSE information_schema;
ReplyDeleteSELECT view_definition FROM VIEWS where TABLE_NAME = v_checktest;