Egor Egorov wrote:
Colleen Dick <[EMAIL PROTECTED]> wrote:
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable' AND desc.d_field = Field;
so the resultset would look like a regular DESCRIBE <table> except it
would also include my tacked on comment.
I KNOW the need for this will be obsoleted in mySQL 5 but people will be
stuck on prev versions for the next 2 years.
Any clever way to do this or fake it so everything is in one resultset?
I already did it in the obvious boneheaded way and as always when that
happens one things "THERE HAS TO BE A BETTER WAY"
still on 3.23
You can't mix JOIN and DESCRIBE TABLE.
Retrieve data with DESCRIBE TABLE statement and then use programming language to put result of the DESCRIBE to the test of SELECT query.
Yes, that is what I had to do. It is klunky.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
