This blog post has moved. Please find it at:
http://www.mpopp.net/2006/03/still-no-access-to-the-original-view-definition/.
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
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 ;-).
About Me
Links
Blog Archive
-
▼
2006
(124)
-
▼
March
(15)
- These are really bad news ...
- My MySQLUC departure is just a month away
- Have you ever needed your mobile phone to connect ...
- Triggering emails
- What's the first thing that I see when I get up?
- Five reasons
- JDBC Metadata, MySQL, and Oracle Recipes
- Still no access to the original view definition
- How to calculate the sizes of your databases
- A little look ahead to MySQL 5.2
- My current MySQL UC plan (still subject to change)
- How to get a MySQL copy from the development source?
- Another call for help on a bug report
- Smart moves by MySQL AB
- The PROCEDURE ANALYSE option
-
▼
March
(15)
3 comments:
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.
thank U dear friend
USE information_schema;
SELECT view_definition FROM VIEWS where TABLE_NAME = v_checktest;
Post a Comment