RE: MYSQL + acquiring table relationships

2005-01-20 Thread SGreen
Paul Wallace [EMAIL PROTECTED] wrote on 01/19/2005 06:50:48 PM: Was there a reply to this post? If so, I could have (did) missed it. Can you please resend? Rgds Paul. Sorry, but I never said (woops!) Which language I use depends on where I want to run the script and how often,

RE: MYSQL + acquiring table relationships

2005-01-19 Thread Paul Wallace
Was there a reply to this post? If so, I could have (did) missed it. Can you please resend? Rgds Paul. Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill I prefer to parse the results of a SHOW CREATE TABLE... query. It's rather trivial to

Re: MYSQL + acquiring table relationships

2005-01-17 Thread SGreen
Paul Wallace [EMAIL PROTECTED] wrote on 01/17/2005 12:04:13 AM: Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said

RE: MYSQL + acquiring table relationships

2005-01-17 Thread Dave Merrill
Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill I prefer to parse the results of a SHOW CREATE TABLE... query. It's rather trivial to detect which rows in the result of that statement are your FOREIGN KEYS. They not only indicate which