It's been my experience that table names are case-sensitive in MySQL; you must get the case exactly right to get data from the desired table. Mind you, that is based on SQL issued at the command line. Your driver may make case irrelevant for access from clients.
If your table name is 'course_eng', any "select *" query you do against it with the same "where"/"group by" should give you the same result regardless of whether you are running the query at the command line or from a program. The strangest part of what you describe is that "select * from Course_eng" returns *any* rows at all since you say this table does not exist; I have always gotten a clear error message if I asked for rows from a table which isn't there. Is it possible you *do* have a "Course_eng" table? Is it possible that the "Course_eng" table is in a different database and your program is reading it from a different database? For instance, if your "real" table is "course_eng" and it is in database Foo, could you have another table called "Course_eng" (note the uppercase 'C') in database Bar? If so, then maybe your program is doing a "use Bar" and then "select * from Course_eng" while you are doing "use Foo" and then "select * from course_eng"? I know that's probably far-fetched but it would tend to explain the symptoms. Or could you have "course_eng" and "Course_eng" in the same database, one with 200 rows and one with 40 rows but a bug in MySQL is keeping you from seeing one of them?? Rhino ----- Original Message ----- From: "Nestor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 7:38 PM Subject: RE: interesting....BUG? COMMENTS? > I send this last week and no one commented. > Has anyone run into this simmilar problem? > > -----Original Message----- > From: Nestor Florez [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 18, 2004 10:28 AM > > > I have a php web application that has an admin page for inserting course > records and one for selecting course records > and a client page for selecting course record. > In the admin side I insert records with an "insert into Course_Eng" and I > select records witha "select * from Course_Eng" > In the client side I get records witha "select * from course_eng" > > The kicker is that my client webbased select will only return 40 records (no > limits are being use) but my admin > webbased select returns 200 records. I SSH into the server and when I check > the table "desc course_eng" > look good. > After scraching my head several times I found out that if manually typed on > the server > my select statement as "select * from Course_Eng" I would get 200 records > back, but if I > typed "select * from course_eng" I would get 40 records. > > Is this a bug? or a feature? > > Whe I did a "show tables;", the table name is "course_eng" ther was no > table "Course_Eng" > > If I remember correct in the SQL syntax the case should not matter? > > I change all my inserts and selects to "Course_Eng" that seem to work and > returned me the most records > My server is a Mac OS 10.2 and the Mysql version is "server version: > 4.0.16" > > Any ideas? > > thanks, > > Néstor A. Flórez > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.644 / Virus Database: 412 - Release Date: 3/26/2004 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
