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
--
Alex Pukinskis
Web and Internet Consultant
Satori Design and Development
http://satoridesign.com
[EMAIL PROTECTED]
Release: mysql-3.23.39 (Source distribution)
System: Darwin ermine 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun 9 11:12:48
PD\
T 2001; root:xnu/xnu-124.13.obj~1/RELEASE_PPC Power Macintosh powerpc
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc
Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 15 Jul 17 14:47 /usr/lib/libc.dylib ->
libSystem.dyl\
ib
Configure command: ./configure --prefix=/usr/local/mysql
---------------------------------------------------------------------
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
