Is it an option to drop the table and recreate and repopulate it?
I would give it a try and think that your problem will be gone.
You can easily do that with mysqldump. Ask again if you need more
help.
Alex Pukinskis schrieb am Mittwoch, 22. August 2001, 22:48:26:
> I've made some progress figuring out my case issue. It seems that somehow
> I'm ending up with shadow tables. I discovered this after I ran an ALTER
> command. My db has 4 tables:
mysql>> show tables\g
> +---------------------+
> | Tables_in_hbperfrev |
> +---------------------+
> | employee |
> | perfassessment |
> | perfreview |
> | workgroup |
> +---------------------+
> 4 rows in set (0.01 sec)
> When I look at the perfassessment table, I see the two rows that I added via
> alter, q10 and q11:
mysql>> describe perfassessment\g
> +------------+--------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+--------------+------+-----+---------+----------------+
> | ID | int(11) | | PRI | NULL | auto_increment |
> | AssesseeID | int(11) | YES | | NULL | |
> | AssessorID | int(11) | YES | | NULL | |
> | AssessDate | date | YES | | NULL | |
> | q1 | char(1) | YES | | NULL | |
> | q2 | char(1) | YES | | NULL | |
> | q3 | char(1) | YES | | NULL | |
> | q4 | char(1) | YES | | NULL | |
> | q5 | char(1) | YES | | NULL | |
> | q6 | char(1) | YES | | NULL | |
> | q7 | char(1) | YES | | NULL | |
> | q8 | char(1) | YES | | NULL | |
> | q9 | char(1) | YES | | NULL | |
> | ReviewID | int(11) | | | 0 | |
> | q10 | varchar(255) | YES | | NULL | |
> | q11 | varchar(255) | YES | | NULL | |
> +------------+--------------+------+-----+---------+----------------+
> 16 rows in set (0.00 sec)
> but when I capitalize (PerfAssessment) those two rows are not there:
mysql>> describe PerfAssessment\g
> +------------+---------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+---------+------+-----+---------+----------------+
> | ID | int(11) | | PRI | NULL | auto_increment |
> | AssesseeID | int(11) | YES | | NULL | |
> | AssessorID | int(11) | YES | | NULL | |
> | AssessDate | date | YES | | NULL | |
> | q1 | char(1) | YES | | NULL | |
> | q2 | char(1) | YES | | NULL | |
> | q3 | char(1) | YES | | NULL | |
> | q4 | char(1) | YES | | NULL | |
> | q5 | char(1) | YES | | NULL | |
> | q6 | char(1) | YES | | NULL | |
> | q7 | char(1) | YES | | NULL | |
> | q8 | char(1) | YES | | NULL | |
> | q9 | char(1) | YES | | NULL | |
> | ReviewID | int(11) | | | 0 | |
> +------------+---------+------+-----+---------+----------------+
> 14 rows in set (0.00 sec)
> So clearly I have duplicate tables, and this explains all the case
> sensitivity problems I was having earlier. But why doesn't the second one
> show up when I do "show tables"? And how do I get rid of the second one?
> Any help is much appreciated, as I've been banging my head against the wall
> for days. Again, this is 3.23.39, compiled from source, running on OS X
> Server (details below).
> Another question: I'm trying to remove some unused databases, but this
> command:
> ./mysqladmin -u root -p drop ac
> (where 'ac' is the database name) doesn't seem to actually remove them from
> the mysql database. Is there another command that completely removes
> databases?
> Thanks,
> -Alex
Herzlich
Werner
--
MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Dr. Werner Stürenburg <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant
/_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany
<___/ www.mysql.com +49-5224-997-407 Fax -409
---------------------------------------------------------------------
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
