Yes, it is connecting to the same server each time, it is very strange. I
have tried moving the entire database to a different server, and I seem to
encounter the same problem as well. It is almost as if the tables
themselves have an issue which is causing the problem.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 11:49 PM
To: Chris Stark; [EMAIL PROTECTED]
Subject: Re: Disappearing of New Inserts to MyISAM table
At 23:05 -0500 3/14/02, Chris Stark wrote:
>Hi Everyone,
>
>I am in kind of a jam, and I could use some help. Hopefully someone out
>there has encountered something similar to this. I have a MySQL database,
>and I am using Java to make the connection to the database. At one point
in
>the execution of my app, I need to issue an ALTER TABLE command to add a
>column to one of my tables. The command issues successfully, however, if I
>login to the Server itself, and issue a DESCRIBE TABLE command, the newly
>added column is not among the list of columns. When I use WINMYSQLADMIN to
>monitor the database, it to shows the addition of the new column. Only
when
>I login to the server itself does the column not show. It is strange
because
>the command issues flawlessly, and I get no SQL or Java Errors...I have
>checked my permissions on the tables, as well as on the server itself, and
I
>have full rights to do anything I please on the database. Please help me
>out with any advice you may have on this issue, anything would be a huge
>help.
Bizarre.
Perhaps this is a silly question, but are you sure you're actually
connecting
to the same server each time?
>
>Thanks,
>Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
