I'm having trouble with what appears to be a case sensitivity issue.
Essentially, when I use the "right" case for a table name, the query fails,
but when I use the wrong case, the query succeeds.
Here's my table list:
mysql> show tables\g
+----------------+
| Tables_in_ac |
+----------------+
| Employee |
| PerfAssessment |
| PerfReview |
| Workgroup |
+----------------+
4 rows in set (0.00 sec)
So it seems like the table is called "Employee", but this query fails:
mysql> SELECT Email, FirstName, LastName FROM Employee WHERE ID = 3\g
Empty set (0.00 sec)
However, when I use the wrong case for the table name ("employee"), it
works:
mysql> SELECT Email, FirstName, LastName FROM employee WHERE ID = 3\g
+-------------------------+-----------+----------+
| Email | FirstName | LastName |
+-------------------------+-----------+----------+
| [EMAIL PROTECTED] | Jack | Smith |
+-------------------------+-----------+----------+
1 row in set (0.00 sec)
The same results happen if I do SELECT * instead of specifying columns.
My workaround is to call the table "employee" in my scripts, but this is
extremely puzzling. Does anyone have any ideas? I've included my system
information below.
Thanks,
-Alex
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
