Kris,
You can use SHOW CREATE TABLE.
On Fri, Jul 2, 2010 at 7:56 PM, Kris wrote:
> Hello,
>
> I am having trouble finding a way to retrieve the table and field a
> foreign key references by querying MySQL. If you look at the following
> example tables, there is no way after the tables are create
I use c3p0 to manage MySQL connections in my JVM stack and have for
years in many installations, I have never had to do anything special.
If I can connect to the server through the console at the command line
of the client machine using the same credentials, then the stack will
just work. Are you
On Sat, Jul 3, 2010 at 4:00 AM, Grant Peel wrote:
> - Original Message - From: "Rob Wultsch"
> To: "Grant Peel"
> Cc:
> Sent: Friday, July 02, 2010 3:57 AM
> Subject: Re: Updating 4 to 5
>
>
>> On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel wrote:
>>>
>>> Hi all,
>>>
>>> I have serveral se
For example, the following do not provide this information:
- show create table address;
- describe address;
- select * from TABLE_CONSTRAINTS;
- select * from key_column_usage;
For tables not using transactional engines like InnoDB, MySQL discards
foreign key specs, otherwise see "Find c
I am setting up the Softslate web store package that uses Hibernate to
connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection
pooling. While I would love to solve this little problem it would be wiser
if I learn to diagnose the problem. Is there a tool that can run on the
- Original Message -
From: "Rob Wultsch"
To: "Grant Peel"
Cc:
Sent: Friday, July 02, 2010 3:57 AM
Subject: Re: Updating 4 to 5
On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel wrote:
Hi all,
I have serveral servers running mysql 4, and need to update to mysql 5.
It would be good if m
